Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel changes celle when copying ?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel changes celle when copying ?
That is presumably because the cell reference is absolute and you are
copying into a different row number. You could modify the source formula to =DATO.FORSKEL(Data!G$17;Data!B$17;"y") -- HTH RP (remove nothere from the email address if mailing direct) "-[::::Shamran::::]-" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 pivot chart/table copying vs Excel 2003 | Charts and Charting in Excel | |||
copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
Come selezionare solo celle con font rosso con visualbasic | Excel Discussion (Misc queries) | |||
Copying blank excel worksheet into additional excel workbooks | Excel Discussion (Misc queries) | |||
colorize celle from a range of date | Excel Programming |