ListObject.Range (Excel)

Returns a Range object that represents the range to which the specified list object in the list applies.

Dim rngRange As Range
Set rngRange = ActiveCell.ListObject.Range