VBA Autofilter question
Posted: February 5th, 2005, 2:14 am
by LawfulEvil
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?
VBA Autofilter question
Posted: February 5th, 2005, 3:30 am
by terrorbyte
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.