Hi Lilbit

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

--

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


"Lilbit" wrote in message lkaboutsoftware.com...
Here's a doozy: I have a workbook with 12 worksheets. I need to make a
workbook for each worksheet. Each workbook will be named similarly with
the officer's name added in parentheses; (i.e., Workbook1:
Accts12-31-07(George); Workbook2: Accts12-31-07(Hanson)). Is this
possible. Thanks!!

--
Message posted using http://www.talkaboutsoftware.com/gro...eet.functions/
More information at http://www.talkaboutsoftware.com/faq.html