ListObject.HeaderRowRange Property

Syntax

expression.HeaderRowRange

expression A variable that represents a ListObject object.

Example

The following example activates the range specified by the HeaderRowRange property of the default ListObject object in the first worksheet of the active workbook.

Sub ActivateHeaderRow() Dim wrksht As Worksheet Dim objList As ListObject Dim objListRng As Range Set wrksht = ActiveWorkbook.Worksheets("Sheet1") Set objList = wrksht.ListObjects(1) Set objListRng = objList.HeaderRowRange objListRng.Activate End Sub

See also:

• ListObject Object
• ListObject Object Members