Using Variables in R1C1 formulas

A

Alex R

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"
 
N

Niek Otten

Hi Alex,

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

--
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.
|
| for example
| Dim x As Integer
| x = 4
| Range("B1").FormulaR1C1 = "=R[x+1]C"
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Word macro that can call cells out of Excel for a find and replace 0
Range.Find problem 3
How to create a variable selected range 9
Macro to search range for a portion of a specific value and if findit - then paste formula in anothe 2
Six columns randon no.'s no dupes 6
ListObjects - VBA code that worked in previous versions of Excel doesnot work in Excel 2013 0

Top