Hello all,
I have a very long spreadsheet where I have recorded a macro to take you
back to a cell reference up near the top of the spreadsheet. This macro is
assigned to a button.
Trouble is, I now need to delete some rows & columns of the spreadsheet and
when I do that the button no longer takes me back to the right cell. If I
delete a row, it takes me to the cell one row above. Same with columns.
Is there some way of amending the code so that it always goes back to that
same cell, even though I delete rows/colums?

Thanks muchly!