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