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