Hello

Can't seem to find a solution searching through various forums searches.

I would like to hide all blank rows within a Named Range : Range1 (A1:E8)

ie

from this:

..A B C D E

1 x x x x x
2
3 . x
4
5 x x x
6
7 . . x x
8 x


to look like this when rows are hidden:

..A B C D E

1 x x x x x
3 . x
5 x x x
7 . .x x
8 x


Thanks for any help

~Jeff