Clear All VBA Codes and formulas

**YasserKhalil** · 11-03-2014, 02:48 PM

Originally Posted by Loganeb

These were the instructions at the top:

Thank you for guiding me I didn't notice that at all
Thank you very much for this great forum.

Just the second point to turn all the formulas to just values

**Loganeb** · 11-03-2014, 03:44 PM

Hey YasserKhalil,

Here you go. Most efficient code I ever found to do this:

Sub Formula_Zapper() 
    Worksheets.Select 
    Cells.Select 
    Selection.Copy 
    Selection.PasteSpecial Paste:=xlPasteValues 
    ActiveSheet.Select 
    Application.CutCopyMode = False 
End Sub