Convert cells(1,1) into "A1" and vice versa

Question

I am working on an worksheet generator in Excel 2007. I have a certain layout I have to follow and I often have to format cells based on input. Since the generator is dynamic I have to calculate all kinds of ranges, merge cells, etc.

How can I convert values like this?

Cells(1,1) into A1 and vice versa

Are you *sure* you need to do this? I'd sure like to see an example in which it is necessary to do something like this. — Jean-François Corbett, Jun 07 '11 at 09:07
@Jean-François Corbett - I'm iterating through my sheet (in macro) having coordinates, but I want to create equations with human-friendly "A1" format. — witkacy26, Mar 10 '18 at 18:24

Anders Lindahl · Accepted Answer · 2011-06-07T09:01:37.007

143

The Address property of a cell can get this for you:

MsgBox Cells(1, 1).Address(RowAbsolute:=False, ColumnAbsolute:=False)

returns A1.

The other way around can be done with the Row and Column property of Range:

MsgBox Range("A1").Row & ", " & Range("A1").Column

returns 1,1.

edited Jun 07 '11 at 09:01

answered Jun 07 '11 at 08:53

Anders Lindahl

41,582
9
89
93

1

alternatively `.Address(0,0)` – depperm Apr 24 '19 at 13:15

Convert cells(1,1) into "A1" and vice versa

1 Answers1

Linked