Excel return range reference

[John.S.Mill]

use macro recorder

and record the equivalent of ctrl-shift-right-down right-click-row-selection DELETE

you’ll see in the VBA code something with “end” in the Range.

[dr_t_non-fan]

Seems like tables suck

[1695814]

True, but they suck the least.