relative or absolute Rows and Columns indexes

[mayki76]

I am using FormulaR1C1, as in:
Worksheets(sheet1).Range("b5").FormulaR1C1 = "=R[1]C[2]"
Sometimes the index will be raltive to the current cell (in this case, "c7") and sometimes absolute (in this case, "b3").
How can I conrtol it?

 

[TonyJollans]

Hi mayki76,

I don't quite follow your example.

R[1]C[2] is relative, and in B5 should refer to cell [blue]D6[/blue]

R1C2 would be absolute and refer to cell [blue]B1[/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[mayki76]

Hi Tony,

thanks. i might got confused, but i see you managed to understand my problem.