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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 3
R1C1 reference style as default while opening Excel 3
setting one worksheet cell range reference to another worksheet 1
How Can I return the XValues of the Series collection object ? 10
.ReferenceStyle=xlA1 Converting Relative to Absolute References? 3
formattig word paragraphs from excel 5
Question on this conversion code switching between r1c1 to A1 format tia sal2 2
refer to a particular cell in r1c1 style 11

Back
Top