Autofilter/Exceptions - (An easy one - I think) !!!

[shahzadbux]

I have a line of code below:

Worksheets("Week 1").Range("a8:a67").AutoFilter field:=1, Criteria1:="Not Used"

Doed anyone know how to make the critera not equal to "Not Used". i have tryed Criteria1:= NOT "Not Used" - Doed not work!!!



_________________
Thankx

Shahzad Bux
This message was edited by shahzadbux on 2002-10-30 08:41

 

[k209310]

try

Worksheets("Week 1").Range("a8:a67").AutoFilter field:=1, Criteria1: <> "Not Used"

 

[shahzadbux]

That did't work, it seems that you must have the = sign there. Any other suggestions?