shahzadbux
New Member
- Joined
- May 20, 2002
- Messages
- 31
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
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