autofilter and VBA

[wu88]

Does anybody know how i can scroll through the results of an autofilter using VBA while skipping the hidden rows?

For example, I autofilter a list (with VBA) and the first result is on A600 - although it's displayed as if it were on A2. If I'm on A1 and try to activecell.offset down one, it goes to A2 (hidden in this case) and not A600 like i would like. any ideas?

thanks
-Nick

 

[Juan Pablo González]

What I usually do is use the SpecialCells method to set a range of the visible cells only. Then, you can just loop in THAT range, without needing to check if the row is visible or not.

 

[wu88]

Worked perfect. Thank you.

greetings to Colombia - i have a lot of family down there.