Hi all,
I'm an excel noob and I've been using this script I found online for a few years now to remove Formula's by just doing a mass copy/paste as value.
I was wondering if there's an IF statement or something I can add to it to exclude a sheet IF name equals true.
Sub Formula_Zapper()
Worksheets.Select
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
ActiveSheet.Select
Application.CutCopyMode = False
End Sub
If there is a better way of doing the above I'm also open to suggestions