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