Thread
:
Using Variables in R1C1 formulas
View Single Post
#
2
Posted to microsoft.public.excel.programming
Niek Otten
external usenet poster
Posts: 3,440
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 With Quote
Niek Otten
View Public Profile
Find all posts by Niek Otten