I neglected to include the test for a blank cell in my original post.

Assume you put a formula in cell B5 that tests whether B2 is blank, and if
B2 is blank, you have a 1 entered in B5: =IF(ISBLANK(B2),1,""). Then you can
use the following macro to hide rows 1:2

Sub Hiderows()
If Range("B5") = 1 Then
Rows("1:2").Select
Selection.EntireRow.Hidden = True
Else
Rows("1:2").Select
Selection.EntireRow.Hidden = False
End If
End Sub


--
Brevity is the soul of wit.


"cdstorage" wrote:

I want to set up a logical condition : If a specific cell is blank then hide
row.

Can this be done and how would you recommend implementing