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

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