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