How to convert from R1C1 to A1 style (Excel 2013- VBA)?

[ntc_chanh]

Hi All

I had some problem when convert R1C1 to A1
Ex:

Dim aCell as String 'A1 style
Dim rcCell as String 'R1C1 style

aCell = range(rcCell).address(ReferenceStyle:=xlA1) 'Notworking with some error: Method 'Range' of object '_Global' failed
rcCell = range(aCell).address(ReferenceStyle:=xlR1C1) 'Working like a charm

Thanks

 

[TMShucks]

What does the variable rccell have in it? If it is something like R1C1, that's not a valid cell reference, hence the issue.

Regards, TMS

 

[RoryA]

You could use:

aCell = Application.ConvertFormula(Formula:=rcCell, fromreferencestyle:=xlR1C1, toreferencestyle:=xlA1)

 

[Kaper]

What is value of string rcCell before you call

aCell = range(rcCell).address(ReferenceStyle:=xlA1)

if it's like R1C1 then its not proper address for ramge.

So you shall rather use ConvertFormula for this.