JZB
03-17-2010, 06:57 AM
Hi all
i am trying to incorporate a lastrow variable into an autofilter.
The following is not working :dunno
LASTROW = Range("A65536").End(xlUp).Row
Rows("1:1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$I$" & lastrow & ").AutoFilter Field:=5, Criteria1:="0.16"
any ideas?
i am currently working with lots of data and so loops are very slow.
much appreciated for the help
Thanks
JZB
i am trying to incorporate a lastrow variable into an autofilter.
The following is not working :dunno
LASTROW = Range("A65536").End(xlUp).Row
Rows("1:1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$I$" & lastrow & ").AutoFilter Field:=5, Criteria1:="0.16"
any ideas?
i am currently working with lots of data and so loops are very slow.
much appreciated for the help
Thanks
JZB