How to copy cells value and not formula
 

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

How to copy cells value and not formula
 

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


--

HTH

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


"kaiserlich" wrote in message
...
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