I am trying to add this to my workbook but I am not able to get it to work properly
what I would like to do is if cell C21 is Blank/Null then hide row range 23:30
If Range("c21") = "" Then
Rows("23:29").EntireRow.Hidden = True
Else
Rows("23:29").EntireRow.Hidden = False
End If
End Sub
Bookmarks