This is the fastest, most efficient way I could come up with to convert every formula in a workbook to values.
Interesting in that it's processed with a single action regardless of the number of sheets in the workbook. Typically people try to do this by stepping thru the sheets; it's not as efficient. And there's a difference between Sheets.Select and Worksheets.Select, be careful not to change that.
...of course once you understand the macro, you may realize it can be done very quickly manually as well. Which is also a good thing to know. :fyi: