convert all formulas in a range to values excel

Macro 46: Convert All Formulas in a Range to Values In some situations, you may want to apply formulas in a certain workbook, but you don’t necessarily want to keep or distribute the formulas with your workbook. In these situations, you may want to convert all the formulas in a given range to values. How […]