Using Variables in R1C1 formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex R - 24 Jan 2008 16:43 GMT

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 to this Message

Niek Otten - 24 Jan 2008 17:09 GMT

Hi Alex,

Range("B1").FormulaR1C1 = "=R[" & x+1 & "]C"

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|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.
[quoted text clipped - 3 lines]
| x = 4
| Range("B1").FormulaR1C1 = "=R[x+1]C"

Reply to this Message