filmov
tv
VBA to Convert Formulas to Values

Показать описание
In this video I show you how you can run a macro that will convert all of your formulas to values. VBA code below:
Sub ConvertToValues()
With ActiveSheet.UsedRange
.Value = .Value
End With
End Sub
Sub ConvertToValues()
With ActiveSheet.UsedRange
.Value = .Value
End With
End Sub