VBA syntax to indicate times/multiply operator after "Like"

D

Dennis

Using XL 2003 & 97

In VBA code what is the correct syntax after "Like"
(to indicate "wildcard before" + Multiply sign (Asterick) + "any number" +
"wildcard after."

The challenge is how to code the use of the Asterick
1) as a wild card; then
2) as an operator; then
3) as a wild card again

Attempted:
Like "*" & * & "#*"

Thoughts?

TIA

Dennis
 
J

JE McGimpsey

From XL/VBA Help ("Like operator")
Note To match the special characters left bracket ([), question mark (?),
number sign (#), and asterisk (*), enclose them in brackets.
Click to expand...

note the second "s" in "asterisk".
 
Top