Hide unhide blank rows?

Hello

I came across this code which hides /unhides blank rows between data cells in a column range. When double clicked, It searches for the next cell with data and hides all the blank rows in between.

It works great for hiding the blank rows, but if double clicked again, it unhides all of the rows from the active cell down.
Ideally I would like it to unhide only those hidden rows between the active cell to the next cell with data.

I've been racking my brain for hours trying to modify this with no success.
Any ideas how can this be modified?

Please Login or Register  to view this content.

Thanks for any help

Jeff

Thanks, DGagnon

But it still yields the same results. The code needs an addition which only unhides the rows between the active cell and the next cell with data.

As an example: when all blank rows are unhidden:

.......A...B...C
11
12...data
13
14
15...data
16
17
18
19...data
20

when blank rows are hidden.

.......A...B...C
11
12...data
15...data
19...data
20

Ideally if all blank rows are hidden, and cell A:12 is double clicked, it should only reveal the Rows between the active cell, A:12 and the next cell with data A:15

.......A...B...C
11
12...data
13
14
15...data
19...data
20


The current code unhides all empty rows.. (as in the first example )



Thanks for the help on this!

Jeff

Beautiful!

Thank you very, very much DGagnon!!