You can use the Copy method of the Worksheet object to copy a
single sheet to a new workbook.
Worksheets("Sheet1").Copy
Once this line of code is executed, the new workbook will be the
ActiveWorkbook.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Spencer Hutton" wrote
in message
...
is it possible to save just one sheet of a workbook in it's own
new workbook?
i have a workbook with 3 sheets in it. how can i copy sheet1
to a new
workbook, and save it under the filename "savedbook". TIA.