iterate through SpecialCells(xlCellTypeVisible) Row#, Range.Address

Hi,

My problem is that now that I have added a filter there are only 3 visible cell in the range, but "LastRow" is echoing 97, which is correct because that is where the last cell is, but I dont want to iterate through all of the hidden rows till I get to 97.

Could someone tell me how I need to structure my current ForLoop:

Please Login or Register  to view this content.

So that I could use this:

Please Login or Register  to view this content.

Im lost & I have been on this all day. Im wish I came here & asked 1st thing this morning. I wasted a whole day #facePalm#


TIA

~Note~
This is how I was gonna do my Range I tested it & it works. I just dont know how to put it all togehter with a ForLoop.

Please Login or Register  to view this content.

One way:

Please Login or Register  to view this content.

Hi & Thx for the lightnig fast reply & your help.
Also too, thx for helping so many others, & sharing your knowledge. You' ve saved my bacon more times than you know.

@ dlow

You're welcome.

@ berlan

That's very kind of you, but I think it's not real robust and will require some tweaks. I don't have much occasion to code around filters.

Its really quite good. JMHO

Please Login or Register  to view this content.

Hi, well it doesnt seem as though I need to add another loop.

So how can I get the next up coming "X" row# without messing up my loop?

or could my forLoop release 2 range/rows @ 1 time

~Update~

I think I might have it. [Debug.Print rRow_i.Offset(1)]

I need to test with a larger dataSet though, right now I only have 3 Cell in this sheet.
Maņana