looping in filtered range by rows

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:

Please Login or Register  to view this content.

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

Unless you got to paste the filter cells in to a range, looping is not going to work. Why? Because when you filter the data, the filtered data is turned in to an "Area". It means, you only get one or two rows, followed by a blank row and then again get one or two rows and pattern continues. In effect, you are looping through an area, not a range.
Why can not you just loop though the raw data without filtering and find out if each cell in column A has a special value? If you could attach a sample with a desired result, I might have a go.

I thought it would be easier to make the code to have the filtering first then make the analysis instead of looping the whole range which has 10000 lines
I also thought it would be quicker, as I have many things to check, but all filter should result a few rows only.

Okay! Let me clarify.
Yes, you can copy the filtered cells in a range, that is, in to a sheet, then you can loop through each this cells and do the rest.
However, you can NOT load the filtered cells in an array. If you can, they would be much faster. I do not think, you can avoid a loop, so why do you need to loop twice?

I am not sure I totally understand.
Can you pls clarify how to check if column A in the filtered area = "myvalue"

Thanks for your help

what I don't understand, what are the types ofar and rw, and how do I know, if rw.value is referencing column A?
Sorry, the if question is a a bit silly.

Which bring you back to double looping?

Sorry again, I mistyped the source.
it is not only for column A, but "A:F", let's say. In this case how do I reference a cell within a row?

I make the filtering on the header, like A:AT
Then I need to make a lot of check, like
If (A="Value1" or A="Value2) And B="Value3" then
...

Sorry for the confusion. However, I understood your solution and it completely answers my question, thanks a lot.