Does that mean just take the "Not" out and leave my array the same - or will this effect my array? - I'm guessing notOriginally Posted by mvidas
Also I figured out that "FVDM" cannot be the first two letters, the bummer is that in this case I want to allow "FVDW" but not "FVDM" so I need the fourth letter - but this is the only one where I need the fourth letter - I know this will sound dumb but can I use the * for letters I don't care about like:
[VBA]
If Exclude(UCase(Left(Intersect(CLL.EntireRow, Nm), 4)), Array("PE**", "PS**", _
"FVDM", "WM**", "AS**", "PC**", "KN**", "NC**", "DW**", "GO**", "WP**")) Then[/VBA]
Wouldn't this be nice??![]()