View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin McLean Kevin McLean is offline
external usenet poster
 
Posts: 3
Default Multiple Filter in VBA

I have an excel sheet with 7 columns of data and I would
like to write VBA to filter the 3rd and 4th columns for
the value "0.00". If a record has zero in both the 3rd
and 4th columns I want it displayed. Otherwise, I want it
to be filtered out.

I used the record funcation and received this output:

Selection.AutoFilter Field:=3, Criteria1:="=0.00",
Operator:=xlAnd
Selection.AutoFilter Field:=4, Criteria1:="=0.00",
Operator:=xlAnd

Please help.

Thank you,
Kevin