You received two excellent answers that avoid using the clipboard. If you
actually want to do a copy and paste

worksheets("sheet1").Range("A1").copy

Worksheets("sheet2").Range("B9").PasteSpecial xlValues

(done in two separate commands).

--
Regards,
Tom Ogilvy


"jimmy" wrote:

Which command is copy the cell value instead of the formula?

Thank you