Ok, there is still a problem. When I select the range of cells. the first
one selected becomes active so if I say ignore the error and continue, it
populates the active cell with the name "Tony" still. What can I do?

Gary Keramidas wrote:
try adding this as the first line and see if it helps

On Error Resume Next

I am trying to use selection.find for a word that may or may not be in the
specified search. My problem is that when I do the selection find and it
[quoted text clipped - 17 lines]
NOT
find the word "Alternate". How can I write the code so it will work?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1