(un)hiding a row

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hi,

I would like to hide a row and, depending on a specific value in cell D55,
should automaticaly unhide the row.

Does anybody know if this is possible and if yes, how?

Txs in advance
 
Hi Michael
Right-click on your Worksheet tab, select view code and paste and amend
accordingly the following sample code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$55" Then
If Target.Value = 10 Then 'or whatever value
Rows(4).EntireRow.Hidden = False 'unhide row #4
End If
End If
End Sub

HTH
Cordially
Pascal
 
Txs a lot,

exactly what i needed!

Michael

papou said:
Hi Michael
Right-click on your Worksheet tab, select view code and paste and amend
accordingly the following sample code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$55" Then
If Target.Value = 10 Then 'or whatever value
Rows(4).EntireRow.Hidden = False 'unhide row #4
End If
End If
End Sub

HTH
Cordially
Pascal
Click to expand...
 
Back
Top