You can use datafilterautofilterfilter on it hide Record a macro
OR
for each c in range("b6:b43")
if Ucase(c)="Y" then c.entirerow.hidden=true
next c
--
Don Guillett
SalesAid Software

wrote in message
oups.com...
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