ListObject.InsertRowRange (Excel)

Returns a Range object representing the Insert row, if any, of a specified ListObject object.

If the Insert row is not visible because the list is inactive, the Nothing object will be returned.

Dim rngInsertRowRange As Range
Set rngInsertRowRange = ActiveCell.ListObject.InsertRowRange