I think you assumption is wrong. Copying the sheet should not take long.

If it does, you need to clean it up.

Unused cells past the UsedRange are usually virtual - so they take not time
to copy since they are not there and are not copied.

If you do Edit=Goto=special and select last cell and end up way past your
data, you need to clean up your sheet (delete entire rows and columns that
are unused - not cells, ENTIRE rows and columns). If you don't end up way
past your data, then it shouldn't take but a 'blink of the eye'.

--
Regards,
Tom Ogilvy

"clara" wrote:

Hi all,

Most part of my sheet is empty, so if i copy the sheet as a whole it will
take long, so I would like to copy part of it as a new added sheet into
another workbook. By the way, during the copy I need to keep the layout of
the new added sheet as the same as original one( especially the merged
cells), how can I do the two things?

Clara
--
thank you so much for your help