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