Working with visible rows

[circaa]

Hi guys !

I hide rows on my sheet using the autofilter method. Then I wanna loop through ONLY the visible rows (to use the information they contain).

I know I could loop through all rows and use the .hidden property to find them but I'm looking for a faster way since my sheet contains close to 6000 rows.

There must be a way...maybe with the specialcells method ??

Thanks

[Bob Phillips]

Use SpecialCells.

Something like

Dim cell As Range
For Each cell In ActiveSheet.UsedRange.Columns(1).SpecialCells(xlCellTypeVisible)
   'do something
Next cell

[circaa]

Solved !

Thanks that's exactly what I was looking for