VBA Autofilter question

LawfulEvil · February 5th, 2005, 2:14 am

Dear all,How can i get the result from excel autofilter?for example: Cells.AutoFilter Field:=2, Criteria1:="aaa" Cells.AutoFilter Field:=3, Criteria1:="bbb"it return 10 rowshow can i get these 10 rows into variant?

terrorbyte · February 5th, 2005, 3:30 am

I haven't tested this, LawfulEvil, but I am pretty sure that if you select the range after the AutoFiler and do a "Range.Copy" in VBA and assign it to a Variant, you should have the rows you want.This is how the front end of Excel works.Good luck.