I need my script to detect if worksheet(s) exist based on some critera and if 1 or more does, ignore the entire script.
I want to add this part at the start of a current script I'm using. If any sheets already exist, it is causing me trouble...
Of course this might not be the ideal way to handle this I would assume, but it simply would be best for me to include it as is and not modify the rest of my script
The only critera that needs to be respected is if any worhseet ends with anywhere in between -1 to -1000 (could be -100, -400, -777)
I was thinking of something like this
If "condition is met" Then
Exit Sub
End If
' rest of the script down below
Would this work? and if so, can someone suggest a script to determine is any sheets with my critera exist
Thank you very much
I want to add this part at the start of a current script I'm using. If any sheets already exist, it is causing me trouble...
Of course this might not be the ideal way to handle this I would assume, but it simply would be best for me to include it as is and not modify the rest of my script
The only critera that needs to be respected is if any worhseet ends with anywhere in between -1 to -1000 (could be -100, -400, -777)
I was thinking of something like this
If "condition is met" Then
Exit Sub
End If
' rest of the script down below
Would this work? and if so, can someone suggest a script to determine is any sheets with my critera exist
Thank you very much