VBA to Clear Formulas out of a Worksheet

[Guzzlr]

Hello All.

I have the following Code:

Sheets("NonFormat").Select
With Selection
    Cells.Select
    Selection.ClearFormats
    Selection.Hyperlinks.Delete
    Application.CutCopyMode = False
    Range("Z1").Select
    Range("A1").Select
End With

This is working in place of pasting special values, which I was having all kinds of trouble with. However, the formulas are still embedded. what is the code to get rid of the formulas?
Thanks for the help

 

[Yongle]

If you want to maintain the values but remove the formulas, try..

With Sheets("NonFormat").UsedRange
    .ClearFormats
    .Hyperlinks.Delete
    .Value = .Value
End With

If you want a clean sheet

Sheets("NonFormat").UsedRange.Clear

Note that I have selected nothing
- there is no need to do so