how to delete the formulas in workbook and let the value remain?

[FIFA]

an excel file have a lot of formulas,I have to delete it but remain the values of formulas,how to write the macro can to delete the formulas in workbook and let the value remain?

thanks

 

[Marc L]

Range.Formula = Range.Value (or UsedRange instead of Range) …

Or a Copy / PasteSpecial by value (see in VBA inner help).
​

 

[FIFA]

Sub delete()
    UsedRange.Formula = UsedRange.Value
End Sub

When runing it,why error?

 

[Marc L]

So you forgot to read VBA inner help !
You must specify just before which is the worksheet to modify
as per sample in VBA inner help of UsedRange …

Other way : activate Macro recorder (noob best friend !)
and operate manually Copy / PasteSpecial by value :
you will get your free own code !
​

 

[Dung Nguyen Xuan]

Awsome!