I don't know of any better way. There is no direct way to "find next
non-hidden cell" or anything like that.
--
- K Dales


"Otto Moehrbach" wrote:

Excel 2002, WinXP
In VBA:
I have a cell below which are sequential X number of hidden rows. I need to
find that number (X) so that I can unhide those rows.
I know that I can loop through the rows below the cell and check if the
row is hidden (and unhide it) until I arrive at one row that is not hidden.
My question is: Is there a better way to determine the number of sequential
hidden rows below a given cell? Thanks for your help. Otto