On Saturday, April 4, 2015 at 2:21:17 AM UTC+11, wrote:
How can I do this the other way round?

Sub Get_Cell_Number()
MsgBox Cells(1).Address
End Sub

e.g. Cells(1,1)
'result = 1

Hi Claus,
That gives the column number.

I want the opposite of this:

MsgBox Cells(16385).Address()