How to copy cells value and not formula

[kaiserlich]

Hi there,

i found something like this to copy a cell in a worksheet to another
worksheet:

Cells(1, 1).Copy Destination:=Worksheets("Sheet2").Cells(1, 1)

This works fine for me for all field expect formula. I wanna copy the Value
of this field but it copies the formula. How can i do this?

Thank you for your advice!

Greetz kaiserlich

[Bob Phillips]

Cells(1, 1).Copy
Worksheets("Sheet2").Cells(1, 1).PasteSpecial Paste:=xlPasteValues


--

HTH

RP
(remove nothere from the email address if mailing direct)


"kaiserlich" <[email protected]> wrote in message
news:[email protected]...
> Hi there,
>
> i found something like this to copy a cell in a worksheet to another
> worksheet:
>
> Cells(1, 1).Copy Destination:=Worksheets("Sheet2").Cells(1, 1)
>
> This works fine for me for all field expect formula. I wanna copy the
Value
> of this field but it copies the formula. How can i do this?
>
> Thank you for your advice!
>
> Greetz kaiserlich