Hi,

i need to loop in a range I filtered previously in order to find cells based on a conditons.


Let's say I make a filter like this:

wsSource.Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$BK" & lrSource).AutoFilter Field:=20, Criteria1:="myfiltervalie"
Now I need to find out, if a column A in each rows in the filtered range has a special value.
Can you pls help me how to do it?

Thank you