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:
(the above code only returns line "1" when I check it with MsgBox zRow. )
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:
Code:
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. )
Last edited: