I have an Excel2007 workbook with four sheets.
I created a macro in one sheet (by recording) and I would like it to have effect in all four.
I have tried to run it in other sheets and I think THAT succeeds.
BUT
there was a problem, so I chose the Debug option,
which showed that the FIRST error is in the starting point;
which I want to be whichever cell I have selected before pressing the macro hotkey
but which, in the recorded macro code, is a SPECIFIC cell.
How can I replace the SPECIFIC cell references in the macro code
with references to a currently selected cell ?
in other words -
what is the code for the references of a currently selected cell ?