Is there a way (VBA) Selection in Array

[mole999]

I have

ActiveSheet.Range("$A$1:$BE$6699").AutoFilter Field:=21, Criteria1:=Array( _
"(D/03/4V", "//", "12/95/E1", "15/19/95", "32/-2/09", "32/80/76", "61/40/07", _
"9E/09/NJ", "C1/No/-L", "GV/E9/N5", "-X-"), Operator:=xlFilterValues

Is there a way to just use a IS NOT A DATE value in the filter

 

[vcoolio]

Re: Is there a way (VBA) Sekection in Array

I think that Mole said a seven night stay at Buckingham Palace!

 

[footoo]

Re: Is there a way (VBA) Sekection in Array

I think that Mole said a seven night stay at Buckingham Palace!

What's the second prize? A fourteen night stay?