Thanks, Ron. Your reply was very useful.

-----Original Message-----
Hi Jeff

ActiveSheet.Copy
or
Sheets("Sheet3").Copy
Create a new workbook with only that sheet

Sub test()
ActiveSheet.Copy
ActiveWorkbook.SaveAs "C:\Yourfilename.xls"
ActiveWorkbook.Close False
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"jpi_chicago"
wrote in message news:22bad01c45d55$0f103420
...
I have a workbook consisting of several worksheets. I'd
like to save only one (1) on the worksheets. Can
someone
point me in the right direction? I assume I need to
write
a macro.

Thanks,
Jeff


.