TableObject.ResultRange (Excel)
Returns a Range object that represents the area of the worksheet occupied by the specified query table.
Dim rngResultRange As Range
Set rngResultRange = ActiveCell.ListObject.TableObject.ResultRange
Returns a Range object that represents the area of the worksheet occupied by the specified query table.
Dim rngResultRange As Range
Set rngResultRange = ActiveCell.ListObject.TableObject.ResultRange