When my macro is copying cells from sheet ! to sheet2 one of my cell changes
?? In sheet1 The cell is lige this : =DATO.FORSKEL(Data!G17;Data!B17;"y") In
sheet2 after copying the result is this: =DATO.FORSKEL(Data!B7;Data!B2;"y").

My macro looks like this:

Sheets("Data").Select
With ActiveCell
Range(Cells(.Row, 18), Cells(.Row, 4)).Copy

Sheets("Beregning").Range("B4").PasteSpecial Paste:=xlAll, Transpose:=True

Regards

Jesper Rasmussen