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:
Now I need to find out, if a column A in each rows in the filtered range has a special value.![]()
wsSource.Select Selection.AutoFilter ActiveSheet.Range("$A$1:$BK" & lrSource).AutoFilter Field:=20, Criteria1:="myfiltervalie"
Can you pls help me how to do it?
Thank you
Bookmarks