View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike[_101_] Mike[_101_] is offline
external usenet poster
 
Posts: 5
Default How do you have range address

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.