I am mystified why people will check if a worksheet exists by using the negative:
If NOT worksheet is nothing then
exists
else
does not exist
endif
VERSUS
if worksheet is nothing then
does not exist
else
does exist
endif
the latter code seems significantly more clear to me. Any insights?
means If worksheet exists
Please Login or Register to view this content.
Edited:
...............Ignore................
Did not read post correctly
Last edited by Sintek; 05-29-2017 at 01:51 PM.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Thank you, Sintek, I appreciated your taking your valuable time to respond.
I guess I objected to the double negative to derive a meaning.
I prefer the second version. Just wanted to make sure I was not getting into any trouble.
bil
Either or I guess:
Please Login or Register to view this content.I prefer the first as I would not use the code unless i want to do something with the worksheet and skip the Else partPlease Login or Register to view this content.
The above codes will error before reaching the "don't exists" branch.
To take advantage of the On Error Resume Next, one could use this contraction.
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Hi !
Or instead just use ISREF worksheet function …
@mikerickson
Of course - Out of range...The above codes will error before reaching the "don't exists" branch.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks