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.
If there is a better way of doing the above I'm also open to suggestionsSub Formula_Zapper() Worksheets.Select Cells.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues ActiveSheet.Select Application.CutCopyMode = False End Sub