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
|