ListObject.TotalsRowRange (Excel)

Returns a Range object representing the Total row, if any, from a specified ListObject object.

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