Looping over a worksheet
Thanks to you both for the ideas. That takes care of the looping part.
Are there any string functions that tell whether a substring is in a
string? Is this valid:
If "Joe" in "Joe was here" then
....
Endif
?
Stephen
Bob Phillips wrote:
Sub show_diffs()
Dim i As Long
Application.Goto Range("A2")
With ActiveCell
Do While .Offset(i,0).Value < ""
If .Offset(i,7).Value = "PASS" AND _
(.Offset(i,12).Value = "POUT" OR .Offset(i,12).Value =
"DIFF") Then
.Offset(i,0).EntireRow.Hidden = False
End If
i = i + 1
Loop
End With
End Sub
--
HTH
Bob Phillips
|