copy sheet
 

Hi,

I wrote four sheets in the one Workbook but I forgot the command how to copy
one sheet to another workbook. Of course, the data of the sheet will be
shown on the new workbook.

Thanks
Jimmy

copy sheet
 

worksheets(1).copy

copies the first worksheet in the tab order to a new workbook.

--
Regards,
Tom Ogilvy


"Jimmy" wrote in message
...
Hi,

I wrote four sheets in the one Workbook but I forgot the command how to
copy
one sheet to another workbook. Of course, the data of the sheet will be
shown on the new workbook.

Thanks
Jimmy