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
|