Thread: How do I hide a row in excel if a certain other cell is populated
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default How do I hide a row in excel if a certain other cell is populated
Hi Teresa,


With an event macro to be inserted in a sheet module ...

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1").Value = 0 Then
'adjust to your need
Range("A1").Offset(6, 0).EntireRow.Hidden = True 'adjust to
your need
Else
Range("A1").Offset(6, 0).EntireRow.Hidden = False
End If
End Sub

HTH
Cheers
Carim

Reply With QuoteReply With Quote