Hi Matt,

Once you've got your active cell try:

ActiveCell.Offset(0, 1) = ActiveCell

0, 1 is no rows and 1 column (-ves also work)

JF

On 30 Jul, 15:30, matt wrote:
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....