finding last row (that is visible) starting from the first row (that is visible)...

[kbishop94]

never mind... I got it! apologies for the 'false alarm'

how do I find the last visible row when starting from the first visible row, but BELOW a certain starting point?

So in the example below, the code would need to locate the first visible row that is below row 3, and down to the last visible row (which is row 22.)

here's what I have so far:

Dim zRow As Long
    zRow = Cells.Find("*", ws.Cells(4, 1), , , xlByRows, xlPrevious).SpecialCells(xlCellTypeVisible).Row

(the above code only returns line "1" when I check it with MsgBox zRow. )

 

[Fluff]

Try

Cells.Find("*", , , , xlByRows, xlPrevious).Row

 

[kbishop94]

Thank you, Fluff. You must of replied right before I edited my post.. . Thank you again

 

[Fluff]

You're welcome & glad to see you figured it out yourelf.