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

Copy paste named ranges

ResolvedVersion 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:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips

Copy paste named ranges

Copy paste named ranges

RE: Copy paste named ranges

Excel articles

Excel tip:

Stop Formula Returning A "#DIV/0" Error