Someting like this :-


Code
-------------------
Sub HideRows()
For r = 20 To 50
If Cells(r, 2).Value = "" Or Cells(r, 5).Value = "" Then
Rows(r).EntireRow.Hidden = True
End If
Next
End Sub

-------------------


--
Message posted from http://www.ExcelForum.com