Hi,

Am Fri, 3 Apr 2015 08:21:13 -0700 (PDT) schrieb :

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

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

what do you want as result? Row number, column number, column character
or cell address?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional