View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
 
Posts: 226
Default Create a Macro with Starting Cell as a Variable

Linda M. wrote:
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.


Try this

Sub CopyNamedRange()
Range("RangeNameHere").Copy ActiveCell
End Sub

--
Regards,

Juan Pablo González