Convert reference style
 

Please help if possible.

I need a function that will convert a cell address
from "R1C1" style to "A1" style.

For example, call the function with "R1423C28" as the
argument and return "AB1423".

Please supply your example code. Thanks in advance.

Convert reference style
 

PK,

Use the Application.ConvertFormula function. E.g.,

Debug.Print Application.ConvertFormula("R1423C28", xlR1C1, xlA1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"pk" wrote in message
...
Please help if possible.

I need a function that will convert a cell address
from "R1C1" style to "A1" style.

For example, call the function with "R1423C28" as the
argument and return "AB1423".

Please supply your example code. Thanks in advance.