ListObject.TotalsRowRange (Excel)

Devuelve un objeto Range que representa la fila total, si la hay, de un objeto ListObject especificado.

Dim rngTotalsRowRange As Range
Set rngTotalsRowRange = ActiveCell.ListObject.TotalsRowRange