View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default copy worksheet and replace

You cannot copy a worksheet into another existing worksheet.

You can copy the contents of a sheet into an existing worksheet.

With both books open.....

In book "A" hit CTRL + a(twice in 2003) to select all then editcopy.

Switch to book "B" and the sheet you wish to overwrite.

EditPaste.


Gord Dibben Excel MVP

On Tue, 12 Apr 2005 18:33:01 GMT, "chiandu" wrote:

Hi all,
I would like to ask how is possible make a copy of one specific worksheet
in workbook "a" and paste it in a existing worksheet in a Workbook "b"
replacing the content.

Thanks in advance.

Marco