Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying formulas to new cell
According to my experience you are correct.
Regards BrianB ======================================= "Ed Bitzer" wrote in message ... To copy a formula (with smart adjustment for the new location) from cRow 4 to cRow 5 where cRow = 5 I can use: ActiveSheet.Cells(cRow - 1, 10).Copy ActiveSheet.Cells(cRow, 10).PasteSpecial Paste:=xlPasteFormulas Is this the "best" way? I am surprised that this: Cells(cRow, 10).Formula = Cells(cRow - 1, 10).Formula does not work. It copies the formula but without adjustment for the new location. Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying formulas from one cell to another | Excel Worksheet Functions | |||
Copying cell formulas | Excel Discussion (Misc queries) | |||
copying formulas to another cell | Excel Worksheet Functions | |||
Copying formulas to new cell | Excel Programming | |||
Copying formulas to new cell | Excel Programming |