Create a Macro with Starting Cell as a Variable

L

Linda M.

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.
 
R

Ron de Bruin

Hi Linda

Try this to copy the range to the activecell

Range("named range").Copy ActiveCell
 
J

Juan Pablo González

Linda said:
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.
Click to expand...

Try this

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