How many rows are hidden?
 

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

How many rows are hidden?
 

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

How many rows are hidden?
 

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
"K Dales" wrote in message
...
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