Consulting

Results 1 to 6 of 6

Thread: Exclude Sheet from Formula

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Oct 2021
    Posts
    3
    Location

    Exclude Sheet from Formula

    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
    Last edited by Aussiebear; 10-17-2021 at 11:30 AM. Reason: Added code tags to supplied code

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •