98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Copy paste named ranges
Copy paste named ranges
Resolved · Medium Priority · Version 2007
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?
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.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Make macros work in newer versions of ExcelIf 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. |
