Dec 31st, 2012, 12:15 PM
#1
Thread Starter
New Member
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
Dec 31st, 2012, 12:27 PM
#2
Thread Starter
New Member
Re: Excel VBA - Does Sheet Exist
I meant the 'Else' portion
Dec 31st, 2012, 12:45 PM
#3
Thread Starter
New Member
Re: Excel VBA - Does Sheet Exist
Disregard, I have discovered the error of my ways.
Jan 1st, 2013, 06:57 AM
#4
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
Forum Rules
Click Here to Expand Forum to Full Width