Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transpose? Offset? Variable starting cell | Excel Discussion (Misc queries) | |||
Macro - Return to starting cell | Excel Worksheet Functions | |||
Returning Macro to Starting Cell | Excel Worksheet Functions | |||
How can I assign a range starting cell based on a variable locati. | Excel Discussion (Misc queries) | |||
How can I assign a range starting cell based on a variable locati. | Excel Worksheet Functions |