Using Like with "and" or "or"

[Ed in Aus]

Hi everyone,

need a little help with a statement failing.

Cells(r, 1).Select
If ActiveCell.Value Like "*.*" Or "*$*" Then GoTo skippy

the current activecell = "Administration" but it brings back an error run time type 13...

not sure what I have done wrong

 

[Sal Paradise]

If ActiveCell.Value Like "*.*" Or ActiveCell.Value Like "*$*" Then GoTo skippy

Try that.

 

[Ed in Aus]

Bingo, thank you so much tried to google but it let me down this time... was much quicker to come in here for a change... usually find what I need out there.

Thanks again

 

[pgc01]

Hi Ed

You could also use a CharList:

If ActiveCell.Value Like "*[.$]*" Then GoTo skippy

 

[Ed in Aus]

ADVERTISEMENT

Thanks for that PGC can you explain what it is doing when you enter this just so I can use it for different scenarios not sure I follow what is happenening

 

[pgc01]

Hi again

You build a CharList by enclosing characters in square brackets. The pattern will mach any one of the characters in the CharList.

Ex:

"*[.$%_]*"

will match any string that includes any of the characters ".", "$", "%" or "_".

HTH

 

[Ed in Aus]

That makes life very easy wish I knew this ages ago