Copy Excel workbook without formulas??

[Webmonkey]

Hi guys!

I am trying to make my very first Excel macro and I have hit a snag. My background is Java, and this my first venture into anything VB or VB like...

I have a workbook with multiple sheets. I need to copy it all to a new workbook with exception of the excel formulas - just the values, number formatting, background colours etc.


The code I have so far does that, but only for the active sheet - can you help me out with looping through the rest?


So far I have the following code working:

Please Login or Register  to view this content.

Now, can anyone encapsulate my code in a loop that will run through all sheets in the workbook? thanks!

[snb]

Please Login or Register  to view this content.

[Webmonkey]

I tried a lot of code now, but always end up with a new wookbook, where all cells which should have a value in them, instead display "#VALUE!"

like this code:

Please Login or Register  to view this content.

[royUK]

One workbook containing all the original workbook's sheets but no formulas?

Please Login or Register  to view this content.

[Webmonkey]

Thanks for your input guys! The issue have been solved!