Paste following code in Worksheet's code (right-click on tab name, select
Code)

HTH
--
AP

'------------
Private Sub Worksheet_Change(ByVal Target As Range)
With Range("c22")
.EntireRow.Hidden = (.Value = "")
End With
End Sub
'------------

"mohd21uk via OfficeKB.com" <u20517@uwe a écrit dans le message de
news:5eb4fedd25850@uwe...
Hi,

I would like to hide a row if a cell in the row is blank. For e,g.If cell
C22
is blank i would like to hide the row. Is there an easy function that
would
do this or would I have to use a macro.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200604/1