View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Claus[_3_] Claus[_3_] is offline
external usenet poster
 
Posts: 40
Default Why can't i filter two different columns with different criterias like this

Is there a way to check if the 2 crits. results in no rows ?

Leverandor contains Companys
and field 35 is the amount to be delivered.

Some Companys have no amount. I don't want to print these.

Claus

"Claus" skrev i en meddelelse
...
It works

Thank you

"DM Unseen" skrev i en meddelelse
ups.com...
Claus

use the following code:

with Range("E4:AI183").
.AutoFilter Field:=1, Criteria1:=Leverandor,
VisibleDropDown:=False
.AutoFilter Field:=35, Criteria1:="<",
VisibleDropDown:=False
end with

DM Unseen