Help Using Wildcards (specifically-*) with UDFs

I was wondering if any one can help. I've been trying to look up how wildcards work in UDFs. Here is my code:

The UDF:

Please Login or Register  to view this content.

The Sub:

Please Login or Register  to view this content.

In the sub procedure Crit1 and Crit2 the string value NSW in some cells has writing before and after it. For example, "*NSW-HAM". In this case the macro does not catch it in the count. What I would like to do is set up a wildcard like "*NSW*" but it isn't working.

How would that be coded in a macro?

Any help would be appreciated. Thank you!

Originally Posted by Norie

Perhaps.

Please Login or Register  to view this content.

Thank you so much Norie!!! That worked. I was having trouble placing the Like statements! Thanks again!