Resolved >>> Hide Blank rows within a range:

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

Thank you very much, VBA Noob!

..most helpful

~Jeff

Hello, VBA Noob

A follow up question if I may.

..Your code works perfectly with a blank worksheet, utilizing a few columns/rows as a test, However, when I bring it into my final database workbook, it still works, but is very slow.
Even testing an 11 column by 20 row range takes about 8 seconds. (my worksheet length is around 700 rows.)


I'm wondering if there is an alternative workaround to achieve the same result?


I currently have this code (below) in my worksheet. When initiated by a button, it hides blank rows between 2 separate columns and takes about a second to execute.

'Hide Blanks rows in Column "O & R"
Private Sub Btn_HideRowBlank_R_Click()
  Intersect(Range("HideRow_O").SpecialCells(xlCellTypeBlanks).EntireRow, _
  Range("HideRow_R").SpecialCells(xlCellTypeBlanks).EntireRow) _
    .EntireRow.Hidden = True
End Sub

Not sure if this is helpful...

any ideas?

thanks again!

jeff