Duke

Thank you; thank you; thank you

Pretty impressive macro.

Frank

"Duke Carey" wrote:

See Ron deBruin's code for this

http://www.rondebruin.nl/copy6.htm


"Beep Beep" wrote:

I have a workbook that has approximately 30 worksheets in it. Needless to
say this is a very large workbook. If I try and send it to the (30)
departments concerned it takes a while to open etc. What I would like to do
(By way of a Macro) is to set up 30 workbooks with each name of the workbook
from the worksheet tab..

Can do?????????