Create a Macro with Starting Cell as a Variable

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

 

[Ron de Bruin]

Hi Linda

Try this to copy the range to the activecell

Range("named range").Copy ActiveCell

 

[Juan Pablo González]

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