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
|