That was perfect! Thank you very much!

Dave Peterson wrote:
This line:

Set Sourcewb = ThisWorkbook

says to use the workbook with the code.

If that's not what you want, you can keep the code in your personal.xls
workbook, but change the line to:

Set Sourcewb = ActiveWorkbook

Just make sure the workbook that should be split is active before you run the
macro.

I have a workbook with 95 worksheets in it, and I'd like to be able to split
these out into individual workbooks. I looked on Ron DeBruin's site and got
[quoted text clipped - 99 lines]
--
Message posted via http://www.officekb.com


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200912/1