Excel.ListObject.HeaderRowRange.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
ListObject.HeaderRowRange property (Excel)	vbaxl10.chm734084	vbaxl10.chm734084	Excel.ListObject.HeaderRowRange	af7ca1d5-f72f-f369-9946-c64eb0cf9da0	04/30/2019	medium

ListObject.HeaderRowRange property (Excel)

Returns a Range object that represents the range of the header row for a list. Read-only Range.

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

[!includeSupport and feedback]