View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
geebee geebee is offline
external usenet poster
 
Posts: 190
Default autofilter criteria

hi,

i have the following:

Selection.AutoFilter Field:=1,
Criteria1:=Sheets("lookup").Range("BM3").Value, _
Field:=3, Criteria2:=Sheets("lookup").Range("I3").Value

it seems to work when i just have the Criteria1, but when I add the
Criteria2, it shows no rows and doesnt work right.

What am i doing wrong?

thanks in advance,
geebee