Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
R1C1 Notation???
I have the following code in my VB:
Range("ED37").Select ActiveCell.FormulaR1C1 = _ "=-(RC[-118]*R-12C2)" My next procedure in the macro drags the formula down the range of cells, however I want R-12C2 to reference the same cell [EF25] as it is dragged down. Is there a code to do such a task??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
R1C1 Notation???
That doesn't look like a valid formula to me.
I bet you meant: Range("ED37").Select ActiveCell.FormulaR1C1 = _ "=-(RC[-118]*R[-12]C2)" But I can refer to EF25 by using: R25C136 So try: Range("ED37").FormulaR1C1 = "=-(RC[-118]*R25C136)" Clueless wrote: I have the following code in my VB: Range("ED37").Select ActiveCell.FormulaR1C1 = _ "=-(RC[-118]*R-12C2)" My next procedure in the macro drags the formula down the range of cells, however I want R-12C2 to reference the same cell [EF25] as it is dragged down. Is there a code to do such a task??? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
R1C1 notation in VBA code | Excel Programming | |||
Sumproduct with A1 notation instead of R1C1 | Excel Programming | |||
R1C1 Notation in VBA | Excel Programming | |||
R1C1 Notation | Excel Programming |