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

If C3 and C5 are fixed, you already know their addresses so why would you
want to save them. Nevertheless, here is the code

Sub Macro1
'Declare two string variables to store the addresses
Dim sAddress1$,sAddress2$

'When C3 has been selected
sAddress1 = Selection.Address

'When C3 has been selected
sAddress2 = Selection.Address

End Sub

Hope this is what you were looking for.
Alok Joshi

"SMH" wrote:

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