jl's method is how i would normally code to find the string, too, because it
just may not find he string..


--


Gary


"matt" wrote in message
...
That worked perfect Gary. Thanks.
JLG if you read this is there a benefit of doing it your way? It seems more
complicated.

"Gary Keramidas" wrote:

one way
Cells.Find("My String").offset(,1).Copy

--


Gary


"matt" wrote in message
...
Hi,
I figuered out how to search through the sheet and find a string. With
something like Cells.Find("My String").Activate
How do I have it do a .Copy of the cell to the right of that one. So if it
finds the string in "B10" then I want it to Copy "C10".
Thanks in advance....