The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copy whole worksheet

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

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

Training information:

Copy whole worksheet

Resolved · Low Priority · Version 2003

ReplyWed 28 Apr 2010, 18:30Delegate Alison said...

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

For upcoming training course dates see: Pricing & availability

ReplyThu 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.paste

Usually 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.

Excel articles

· Learn How To Separate Text In Excel Into Separate Cells
· The Importance of Data Backups
· Excel Charts As Easy As Pie
· How To Create An Excel 2010 Chart To Show Both A Number And A Percent Data Series
· How Small Businesses Profit from Outside Excel Training

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

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips

How do I convert a decimal to hours/mins eg. If a day=1 and I work .3 of a day on a project, how do I convert that to hours and minutes in a cell?

Thanks
Lee

» Forum post: Excel

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions