Hi hammermw

Yes that is possible

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"hammermw" wrote in message ...
I have a workbook with 100 tabs and I need to send out each of those tabs
separately. I was wondering if there was an efficient way to get each of
those tabs into their own file.