Hi
Have a look he
http://www.rondebruin.nl/copy6.htm
Hope this helps.

--
Andy.


"Sharon" <Sharon @discussions.microsoft.com wrote in message
...
I have a workbook with ~40 individual spreadsheets. Now I am moving them
all
individually and spending tons of time. Is there a way to separate each
spreadsheet into its own workbook at the same time?