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

Copy whole worksheet

ResolvedVersion 2003

Wed 28 Apr 2010, 18:30 Delegate 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:36 Trainer 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.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips

Copy whole worksheet

Copy whole worksheet

RE: Copy whole worksheet

Excel articles

Excel tip:

Use shortcut keys to select rows or columns