HeaderRowRange Property

  • Article

Returns a Range object that represents the header row from a specified ListObject object. Read-only.

expression**.HeaderRowRange**

*expression   * Required. An expression that returns a ListObject object.

Remarks

If a header row is present, a Range object representing the header row for the specified ListObject object is returned. If a header row isn't present, the Nothing object is returned.

Example

The example below saves the header row range information to a variable.

Dim rngHeaderRowRange
Dim objList
        
Set  objList = Spreadsheet1.ActiveSheet.ListObjects(1)
Set rngHeaderRowRange = objList.HeaderRowRange

Applies to | ListObject Object