Dim firstrange as range
..
..
..
set firstrange = Selection

Just remember to dim the variable in the module outside of both macros.
That way it will be static and not loose its value once the first macro exits
--
Gary''s Student


"Mike" wrote:

I need to have the user select a range of cells, click a button to run a
macro, select another range and click another button to run another macro.

I need to save the address of the original range that was selected for
reference in the second macro. What would be the command syntax to save the
address of the initial range so I can reference it again.