highlighting rows when a value has been found
thanks for that.
mike
"Toppers" wrote:
Mike,
Select row or column ....
With Worksheets(1).Range("a1:a500")
Set c = .Find("B", LookIn:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address
Do
Rows(c.Row & ":" & c.Row).Select
Columns(c.Column).Select
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address < firstAddress
End If
End With
HTH
"mike" wrote:
hi,
i am using the find method, and at present it highlights only the value that
i have asked it to found.
i would like it to highlight the entire row or column where the value lies.
is this possible?
look forward to your replies.
thanks
mike
|