This would leave all rows with "b" or "c" values
within myRange visible.

Sub hiderow()
Dim r As Range
Set myRange = ActiveSheet.Range("K2:K100")
For Each r In myRange
If r.Value < "a" Then
r.EntireRow.Hidden = True
End If
Next
End Sub



"Darin Kramer" wrote:



Hi guys,

I have in column K three possible types of data, a,b or c (only one per
cell)

If the value = a or b I want the row to be visible (ie hide all rows
that contain c)

I then need anotehr set of VB to to repeat the excercise for the other
option - ie first unide all, then if value = b or c row is visible (ie
hide all rows that contain a)

If I can just be helped with the first scenario, Im sure I could
replicate it for the second....

Thanks!!!!!

Regards

D



*** Sent via Developersdex http://www.developersdex.com ***