You would need a macro to do that.

Here's an example of a macro that hides rows:

Sub HideRow()
'Hides rows 1:2
Rows("1:2").Select
Selection.EntireRow.Hidden = True
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