Code to split Worksheets into seperat workbooks
It would take me forever to figure out how to code this myself. What I
want is to take a workbook with a dozen worksheets, and create 12
seperate worksheets, filled with the formatting and the values, (similar
to a paste special values only) of each worksheet.
I need the values only because I am using a lot of links to create the
worksheets.
Can anyone point me to some code I can hack up?
Thanx
Phil
|