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

  • Thread starter Thread starter kenji4861
  • Start date Start date
kenji4861 said:
For example... how can I do...

Row, Column to some form like A55
Click to expand...

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)
 
VBA?
msgbox activesheet.cells(55,1).address(0,0)
or
msgbox activesheet.cells(55,"A").address(0,0)
 
Back
Top