If Worksheet like (*Comments*) exists do the following. Use of wildcards in Function

[R_S_6]

Hi All.

I have a very useful function that I have found online:

Please Login or Register  to view this content.

The above function works great - What it doesn't do is allow the use of a wildcard in the sheet name to search for.

What I would like is a modification to the above function or code to allow me to use a wildcard to search for sheets

Please Login or Register  to view this content.

Any help appreciated as always.
Cheers,
Mark

[Domski]

This is one way with a different approach:

Please Login or Register  to view this content.

Dom

[romperstomper]

You could use something like:

Please Login or Register  to view this content.

called as either:

Please Login or Register  to view this content.

for exact match or:

Please Login or Register  to view this content.

for partial match.

If you want specific combinations of wildcards, then you could use Like instead.

[R_S_6]

Thank you both for your help.

I have utilised Dom's solution as I had to get it going ASAP.

I am interested romperstoper how you would utilise the 'Like' coding in your example for combos of wildcards???

Lastly i'm using this code in the following:

Please Login or Register  to view this content.

'Cancel = False' allows the workbook to close. Is there a way I can add to this line to allow it to save without the user input of 'Yes' 'No' 'Cancel'?? a bit like how you would use:

Please Login or Register  to view this content.

Thanks in advance!
Mark

[Domski]

Please Login or Register  to view this content.

Dom

[R_S_6]

Cheers Dom,

Nice One!

[romperstomper]

Untested, but something like:

Please Login or Register  to view this content.

[R_S_6]

Thanks for that Romperstomper - I'll give it a go ;-)