ListObject.Active Property

Syntax

expression.Active

expression A variable that represents a ListObject object.

Remarks

Because there is no Activate method for the ListObject object, you can activate a ListObject object only by activating a cell range within the list .

Example

The following example activates the list in the default ListObject object in the first worksheet of the active workbook. Invoking the Activate method of the Range object without cell parameters activates the entire range for the list.

Function MakeListActive() As Boolean Dim wrksht As Worksheet Dim objList As ListObject Set wrksht = ActiveWorkbook.Worksheets("Sheet1") Set objList = wrksht.ListObjects(1) objList.Range.Activate MakeListActive = objList.Active End Function 

See also:

• ListObject Object
• ListObject Object Members