Pasting a Range

  • Thread starter Thread starter Charles Hoens
  • Start date Start date
C

Charles Hoens

This seems so simple, but I can't seem to get it to work
within a macro.

I have some data which I've placed into a named range,
call it (Range1).

I want to have a macro so that the contents of this range
are copied to the active cell.

All I seem to be able to do in the macro is define a
particular cell, so the copy is always done to the same
cell. I need to copy the data to the cell that's active
when I start the macro.

Any help is most appreciated.

Charlie
 
Charles,

Example with a single cell named "MyRange"

Range("MyRange").Copy ActiveCell

John
 
Back
Top