How Can I Convert A (Row, Column) to Range?

[kenji4861]

For example... how can I do...

Row, Column to some form like A55

Thanks

 

[Paul]

For example... how can I do...

Row, Column to some form like A55

Do you mean that you have two numbers representing the row and column
numbers of the reference that you want, for example 1 (column) and 55 (row)
from which you want the reference A55? If so, use
OFFSET($A$1,row-1,column-1)
which, in your example, would be equivalent to
OFFSET($A$1,54,0)

 

[J.E. McGimpsey]

One way:

=ADDRESS(55,1,4,TRUE)

 

[Dave Peterson]

VBA?
msgbox activesheet.cells(55,1).address(0,0)
or
msgbox activesheet.cells(55,"A").address(0,0)