Hi all,
I know this is relatively straight forward but I can't get it to work properly.
I basically want to have a macro which selects 16 cells from the same row.
When I select a cell in column B - i also want to select 14 cells to the right, and one cell to the left (as well as cell in column B) - I just can't get the macro right.
The row can vary - hence why I can't specify the same cells in my macro.
So if I click in cell B10 - I want the macro to select A10:P10.
If i click in B48 - I want the macro to select A48:P48
Thanks in advance
Bookmarks