How can I refer to an offset from a Form Control Button?
The cell to which the button is attached may move (and change row number
address, obviously) due to row sorting, but I always want the macro used by
the button to select the cell one column to the right of the button and down
to the first blank cell.
There will be multiple buttons on the worksheet that need this behavior--
over one column, down to first empty cell.
I am designer of the worksheet, so I have flexibility on solutions and
alternative approaches.
Thanks in advance.