View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Linda M.[_2_] Linda M.[_2_] is offline
external usenet poster
 
Posts: 1
Default Create a Macro with Starting Cell as a Variable

I want to create a macro with the starting cell as a
variable, not a fixed value.
I want the macro to:

1. Start in a cell location (this cell changes with each
run).
2. Go to a named range.
3. Copy the named range.
4. Return to the starting cell.
5. Paste the named range.

I have not been successful at making the starting cell a
variable.