Moving all worksheets

[jerredjohnson]

I have around 40 worksheets in my current workbook. Is there a fast way to move all worksheets into there own seperate workbook?

[Ron de Bruin]

Hi jerredjohnson

Use this code example
http://www.rondebruin.nl/copy6.htm


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



"jerredjohnson" <[email protected]> wrote in message
news:[email protected]...
>
> I have around 40 worksheets in my current workbook. Is there a fast way
> to move all worksheets into there own seperate workbook?
>
>
> --
> jerredjohnson
> ------------------------------------------------------------------------
> jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236
> View this thread: http://www.excelforum.com/showthread...hreadid=552245
>