ListObject.TotalsRowRange Property

Syntax

expression.TotalsRowRange

expression A variable that represents a ListObject object.

Example

The following sample code returns the address of the Total row in the default list in Sheet1 of the active workbook. The code displays the Total row if it is not displayed already.

Sub DisplayTotalsRowAddress() Dim wrksht As Worksheet Dim objListObj As ListObject Set wrksht = ActiveWorkbook.Worksheets("Sheet2") Set objListObj = wrksht.ListObjects(1) objListObj.ShowTotals = True MsgBox objListObj.TotalsRowRange.Address End Sub

See also:

• ListObject Object
• ListObject Object Members