Active Property
Returns a Boolean value indicating whether a ListObject object in a worksheet is active
expression.Active
expression Required. An expression that returns 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