I have a macro that selects two cells say c3 and c5 at different times in the
same run.
I need to store the cell addresses of C3 and C5 so that the macro can use
them to create a print range by offsetting from the two addresses of c3 and
c5.

The problem is how can I store the addresses of the two cells when the macro
selects them.
If value (say in cell c3) = 3 and the macro selects this cell then I want
the address of the selected cell, here being C3, to be stored for use later .

would appreciate the code that has to be included to do this