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

The Cell number as in Cells(1,1) is the same as Cells(1)
Cells(1,2) is the same as Cells(2).