For some reason I'm having trouble

[Luis939]

For some reason I'm having trouble with wildcards,
I'm going to have some cells written as Newark, NJ.
And so obviously I want cells that DONT match that pattern
so i tried
if activecell.value <> &quot;*, ??&quot; then DO WHATEVER
but its not working

i tried if activecell.value = &quot;*, ??&quot; then do whatever

but even that didnt recognize the cell with Newark, NJ in it

what am i doing wrong, i tried using activecell.text and activecell but they didnt work either, what am I doing wrong, thanks!

 

[nath]

Hi there,

try:

if NOT(activecell.value LIKE "*, ??") then

Nath

 

[Luis939]

THANKS SO MUCH NATH!
Nath short for Nathan?

 

[nath]

You welcome.

Nope, short for Nathalie.

 

[Luis939]

Oh ok, because I was going to say thanks alot man before, but something told me-how do I really know it's a guy. Later!