Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding/Showing Rows
This may seem a little easy to some of you guys, but i am just
starting to lean about excel and vba. So i though i would ask for some help. ================================================== ==================== I currently have on a sheet a list of names from B6 to B43 and then in the next column i have either a yes or no from C6 to C43.(The Yes & No Are determined from another sheet) Is there any way that i can hide all of the rows that contain Yes and only show the rows containing No? Then Is there a way to make sure this keeps occuring so that if i did change the cell from a yes to a no that would be hidden and vice versa if i changed a no to a yes would that then show? This is what i thought could do it but to no success: Private Sub Worksheet_Activate() If C6 = No Then Rows("6:6").Select Selection.EntireRow.Hidden = True End If If C6 = Yes Then Rows("6:6").Select Selection.EntireRow.Hidden = False End If End Sub Any Replies Would Be Appreciated, Thankyou in advance Ash |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding/Showing Rows on Cell H2 Change | Excel Discussion (Misc queries) | |||
hiding or showing rows based on a cell value | Excel Discussion (Misc queries) | |||
Showing or Hiding rows based on data validation list | Excel Programming | |||
userforms showing and hiding | Excel Programming | |||
Showing and hiding columns | Excel Programming |