HeaderRowRange Property

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