| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Variables in R1C1 formulas
I am trying to create a formula in a cell to set the value of the cell equal
to another cell that is a varible number of cells away. for example Dim x As Integer x = 4 Range("B1").FormulaR1C1 = "=R[x+1]C" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Variables in R1C1 formulas
Hi Alex,
Range("B1").FormulaR1C1 = "=R[" & x+1 & "]C" -- Kind regards, Niek Otten Microsoft MVP - Excel "Alex R" <Alex wrote in message ... |I am trying to create a formula in a cell to set the value of the cell equal | to another cell that is a varible number of cells away. | | for example | Dim x As Integer | x = 4 | Range("B1").FormulaR1C1 = "=R[x+1]C" | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formulas using "+" cell reference causes r1c1 in linked sh | Excel Discussion (Misc queries) | |||
| Variables in formulas | Excel Worksheet Functions | |||
| variables in formulas | Excel Programming | |||
| How can I use variables in formulas in VB? | Excel Discussion (Misc queries) | |||
| using variables in formula in R1C1 mode | Excel Programming | |||
Linear Mode
