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