Thread: how do I hide rows in excel based on values input on sheet ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ph8[_49_] ph8[_49_] is offline
external usenet poster
  
Posts: 1
Default how do I hide rows in excel based on values input on sheet ?

in VBA:


Code
-------------------
If Cells(1, "A") = "ValueToTestFor" Then
Cells(2, "B").EntireRow.Hide = True
Else
Cells(2, "B").EntireRow.Hide = False
End I
-------------------


Replace the cell addresses with the respective cells

--
ph
-----------------------------------------------------------------------
ph8's Profile: http://www.excelforum.com/member.php...fo&userid=1987
View this thread: http://www.excelforum.com/showthread.php?threadid=52484

Reply With QuoteReply With Quote