Hi all

i am trying to incorporate a lastrow variable into an autofilter.

The following is not working

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