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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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".
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 I would like to know in a batch file how to indentify computer name by using the first 5 of the name and the last 2 of the name then call runcmd 0
Vlookup in VBA (how to use a dynamic range) 2
VBA syntax to SUM() at two cells below last data item 6
VBA Range Syntax Range(A2:???????) where ??? is Last used cell Col 2
VBA syntax for one-line of code 3
Using Like operator in VBA 6
VBA AutoFilter how to apply 2 ranges for selection to copy 1
Syntax to save ActiveCell to MyActiveCell then select later 3

Back
Top