VBA-Removing formulas

PHOTO

Tue Dec 19 2023 17:50:36 GMT+0000 (Coordinated Universal Time)

Sub RemoveFormulasFromExcel()
Dim Xws As Worksheet
For Each Xws In Worksheets
Xws.UsedRange.Value = Xws.UsedRange.Value
Next
End Sub

Sub RemoveFormulasFromExcel()
Dim Xws As Worksheet
For Each Xws In Worksheets
Xws.UsedRange.Value = Xws.UsedRange.Value
Next
End Sub