auto unhide row if row above contains data

[russkris]

Hi,

Not sure if this is a setting or something within excel.
I want to set up a table and hide all the blank rows that don't contain a date(column B) and unhide a blank row if the row above contains a date.

Any idea if this is do-able?

[tax112]

Hi,

Not sure if this is a setting or something within excel.
I want to set up a table and hide all the blank rows that don't contain a date(column B) and unhide a blank row if the row above contains a date.

Any idea if this is do-able?

Maybe:

Sub russkris()
 Range("B2:B10000").SpecialCells(4).EntireRow.Hidden = True
End Sub