Hide whole row when cel C3 is 0 (zero)
Hi Berry
Rightclick the sheet tab, "view code", paste this in:
Private Sub Worksheet_Calculate()
If Me.Range("C3").Value = 0 Then
Me.Columns(3).Hidden = True
Else
Me.Columns(3).Hidden = False
End If
End Sub
HTH. Best wishes Harald
skrev i melding
oups.com...
Hello,
Who can help me with this next problem?
I want to hide an whole row when the formula in row C give the anser
"0"
The other row are filled!
Who can give me the code for this?
Greets Berry
|