How to convert all formulas to values using VBA
In this tutorial you will learn how convert all formulas to values using VBA macro programming in Microsoft Excel
VBA Code:
'This code will convert all formulas into values
Sub ConvertToValues()
With ActiveSheet.UsedRange
.Value = .Value
End With
MsgBox ("All Formulas are converted to values")
End Sub