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.

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.