Is there a way to modify this VBA code to make a bulk formulas removal in multiple excel files?
This VBA code saves all worksheets as values only
Thank you!
This VBA code saves all worksheets as values only
VBA Code:
Sub Saveasvalue()
'Updateby Extendoffice
Dim wsh As Worksheet
For Each wsh In ThisWorkbook.Worksheets
wsh.Cells.Copy
wsh.Cells.PasteSpecial xlPasteValues
Next
Application.CutCopyMode = False
End Sub
Thank you!