Great, don't try to copy and paste on that worksheet.

--
Regards,
Tom Ogilvy


"EMoe" wrote in message
...

Tom with the box, I will search for a name that is in column one. The
phone number associated with that name is located in column 3. I don't
quit understand what you mean by using 1234567 as a string though.

I would love to see your explanation, however I was able to come across
this code:

Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Static rr
If rr < "" Then
With Rows(rr).Interior
ColorIndex = xlNone
End With
End If
r = Selection.Row
rr = r

With Rows(r).Interior
ColorIndex = 6
Pattern = xlSolid
End With
End Sub


Thanks,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile:
http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=483546