Application.Evaluate use R1C1 reference instead A1 Reference

[Mushy peas]

How can I use R1C1 references instead of A1 references. This is an example of where both collides and A1 references is used instead: Evaluate("=C1") (I want to get the first column values).

 

[MARK858]

From the help file (R1C1 is not included)

 

[Mushy peas]

From the help file (R1C1 is not included)

View attachment 109110

You can try Evaluate("=R1C1")

 

[MARK858]

You can try Evaluate("=R1C1")

and you don't normally need the = sign in Evaluate i.e. for cell A1 value it would normally be

Debug.Print Evaluate("A1")

 

[Mushy peas]

View attachment 109111
and you don't normally need the = sign in Evaluate i.e. for cell A1 value it would normally be

Debug.Print Evaluate("A1")

Strange, I've always been able to use Evaluate("=R1C1"). Perhaps I am using R1C1 references in my preferences. Will send a ss later at my home computer.

 

[MARK858]

Strange, I've always been able to use Evaluate("=R1C1"). Perhaps I am using R1C1 references in my preferences. Will send a ss later at my home computer.

You can use =, it is just not necessary (I have slightly reworded my statement in the post)

 

[MARK858]

Strange, I've always been able to use Evaluate("=R1C1"). Perhaps I am using R1C1 references in my preferences.

Just tested, it works if you are set up as (you do need the = sign with R1C1 ticked).
Edit: but I can't get it to work without a number in both the row and column i.e. =RC3 isn't working

 

[jkpieterse]

You could use convertFormula:

Debug.Print Evaluate(Application.convertformula("R12C8",xlR1C1,xlA1))