Pasting a Range

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
 
J

John Wilson

Charles,

Example with a single cell named "MyRange"

Range("MyRange").Copy ActiveCell

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to copy table of contents to a new doc 0
Need Help with Macro Security 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Pasting a cell into bookmarked table from excel vba 1
Need Help with a VBA subroutine 0
End(xlDown) Issue 1
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
how to get a simple macro to paste value 4

Top