TableObject.Destination (Excel)

Returns the cell in the upper-left corner of the query table destination range (the range where the resulting query table will be placed). The destination range must be on the worksheet that contains the TableObject object.

Dim rngDestination As Range
Set rngDestination = ActiveCell.ListObject.TableObject.Destination