Results 1 to 4 of 4

Thread: Does Sheet Exist

  1. #1

    Thread Starter
    New Member
    Join Date
    Dec 2012
    Posts
    12

    Does Sheet Exist

    I have the attached code that is giving me trouble; this is part of a much larger macro. It will execute one part of the If/Then, depending on if I use an = or > sign. I want the macro to look for a worksheet called "Error Summary", there will only ever be one if it does exist, if it does not exist I want it to simply create a the Then portion.

    Any assistance is greatly appreciated.
    Attached Files Attached Files

  2. #2

    Thread Starter
    New Member
    Join Date
    Dec 2012
    Posts
    12

    Re: Excel VBA - Does Sheet Exist

    I meant the 'Else' portion

  3. #3

    Thread Starter
    New Member
    Join Date
    Dec 2012
    Posts
    12

    Re: Excel VBA - Does Sheet Exist

    Disregard, I have discovered the error of my ways.

  4. #4
    Discovering Life Siddharth Rout's Avatar
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    12,001

    Re: Does Sheet Exist

    Moved from "Does Sheet Exist" into it's own thread.

    Welcome to the forums Jrocket

    You may want to post what you discovered so that others could benefit from it?
    A good exercise for the Heart is to bend down and help another up...
    Please Mark your Thread "Resolved", if the query is solved


    MyGear:
    ★ CPU ★ Ryzen 5 5800X
    ★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
    ★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
    ★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
    ★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
    ★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
    ★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
    ★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
    ★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
    ★ Keyboard ★ TVS Electronics Gold Keyboard
    ★ Mouse ★ Logitech G502 Hero

Posting Permissions

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



Click Here to Expand Forum to Full Width