Maybe

Range("latest").Select
ActiveCell.Copy
ActiveCell.Offset(0, 1).PasteSpecial xlPasteValues

Mike

"Simon" wrote:

Cells.Find("latest").Select
Selection.Copy Destination:=ActiveCell.Offset(0, 1)

I wish to use only the value of the cell.

What is wrong with

Cells.Find("latest").Select
Selection.Copy Destination:=ActiveCell.Offset(0, 1)

Thanks