How many rows are hidden?

[Otto Moehrbach]

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

 

[Guest]

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

 

[Otto Moehrbach]

Thanks for that. I wrote the code to loop through the rows and it wasn't as
bad as I thought it would be. Otto