Convert reference style

  • Thread starter Thread starter pk
  • Start date Start date
P

pk

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
 
Back
Top