Copy paste named ranges

Resolved · Medium Priority · Version 2007

Tue 20 Sep 2011, 16:42 Delegate Matthew said...

Matthew has attended:
Excel VBA Intro Intermediate course

Copy paste named ranges

How do you copy data in a named range from one sheet to another?

Tue 27 Sep 2011, 00:00 Trainer Mark said...

RE: Copy paste named ranges

Hello Matthew,

Here's an example code of copying figures in a range on sheet1 called myrange and pasting to sheet2 at cell B3

Range("myrange").Copy Sheets("Sheet2").Range("B3")

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Mon 3 Oct 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips