Here is a start for you
Sub tryme()
mylast = Cells(Cells.Rows.Count, "A").End(xlUp).Row
For j = 1 To mylast
If Cells(j, 1) = "a" Or Cells(j, 2) < 20 Then
Cells(j, 1).EntireRow.Hidden = True
End If
Next j
End Sub
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"rtwiss via OfficeKB.com" <u46610@uwe wrote in message
news:8c576eb9e664f@uwe...
I would like to display rows that have a certain condition and are others
that do not have this condition to be hidden. I'm thinking of and IF
Statement.
IF column b0 OR column c0 Then
show row
else
hide row
any suggestions?
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200810/1