Hi becaboo77

Try this macro
http://www.rondebruin.nl/copy6.htm

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


"becaboo77" wrote in message ...
I have a file with about 25 tabs (sheets) in it, but I want to save each tab
as a separate file & name the file the tab name. Is there a way to do this
automatically, or will I have to manually move each sheet into a new file &
save it?