get rid of formulas and functions and keep values only

[lezawang]

Hi
Inspired by this post https://www.mrexcel.com/forum/excel...y-removing-formulas-not-converting-table.html

I tried my own code to get rid of all functions in the the whole sheet and replace them with the value but it did not work. Any help would be appreciate. Thank you.

Sub clearformulas()
    Dim ws As Worksheet
    Set ws = Workbooks(1).Worksheets(1)
    ws.Cells.Copy PasteSpecial.xlPasteValues
    Application.CutCopyMode = False
End Sub

 

[Fluff]

Did you see Dante's response in that thread?

 

[lezawang]

Yes I saw it now. Thank you so much. It is working. Thanks all and Dante