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 Training and help » Copy whole worksheet
Copy whole worksheet
Resolved · Low Priority · Version 2003
Wed 28 Apr 2010, 18:30Delegate Alison said...
Alison has attended:
Excel VBA Intro Intermediate course
Excel Pivot Tables course
Excel Dashboards for Business Intelligence course
Advanced Excel Dashboards course
Excel Dashboards for Business Intelligence course
Copy whole worksheet
Hi,
I was hoping you could help with some code to copy a whole worksheet or large block of data into another worksheet (without creating a new worksheet and other than using the copy/paste or loop commands which are running slowly at the moment).
I have found some code using google but have been getting errors with it.
Thanks,
Alison
Thu 6 May 2010, 09:36Trainer Stephen said...
RE: Copy whole worksheet
Hi Alison
Thanks for your question.
If you are copying a whole block of data in its entirety then it may be quicker to use the copy paste method.
Sheets("source").select
Range("A1").currentregion.select
selection.copy
Sheets("target").select
range("A1").select
activesheet.pasteUsually it is bad practice to use the select method as it slows down code execution. In this instance however it might be your best option
Regards
Stephen
Wed 12 May 2010: Automatically marked as resolved.
Training information:
See also:
|
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:Adding date and timeHere are two quick ways to add the date and time to your spreadsheet: |
