Mass conversion of formulas to values?

[samrl1955]

I'm compiling a workbook of close to 100 worksheets from multiple different source workbooks that I need to send externally via email. I there a way to mass convert all formulas on all the worksheets into their values without having to copy worksheets and paste as values one worksheet at a time?

[Craig K.]

Create a Macro using this code

Please Login or Register  to view this content.

After you've pasted all your sheets into the new workbook that contains this code, run it and all your formulas will be replaced with values only.