Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Copy paste named ranges

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Copy paste named ranges

Resolved · Medium Priority · Version 2007

Reply Tue 20 Sep 2011, 16:42Delegate 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?

For upcoming training course dates see: Pricing & availability

Reply Tue 27 Sep 2011, 00:00Trainer 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.

Excel articles

· Summing Up Scenarios With Excel
· How To Create A Data Table In Excel 2010
· Going Against The Grain With Multiple Radio Buttons In Excel
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Microsoft Excel Features and Functions for Accountants

Please browse our web site to find out more about
microsoft excel courses london and other Microsoft training courses.

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips