highlighting rows when a value has been found
 

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

highlighting rows when a value has been found
 

lots of options, depending on how you want to highlight the row but the
simplest might be.....

Rows(Activecell.Row).Select

--
Cheers
Nigel



"mike" wrote in message
...
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

highlighting rows when a value has been found
 

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

highlighting rows when a value has been found
 

or simpler/more intutitive

activeCell.Entirerow.Select

--
Regards,
Tom Ogilvy

"Nigel" wrote in message
...
lots of options, depending on how you want to highlight the row but the
simplest might be.....

Rows(Activecell.Row).Select

--
Cheers
Nigel



"mike" wrote in message
...
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

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