ACTIVECELL LOCATION
 

I would like to know if there is a macro command that will return the
position of the current activcell. This could either be in the format B6 or
6,2

ACTIVECELL LOCATION
 

ActiveCell.Address(False, False)

Regards,
Stefi

€žkt(uk)€� ezt Ã*rta:

I would like to know if there is a macro command that will return the
position of the current activcell. This could either be in the format B6 or
6,2

ACTIVECELL LOCATION
 

Sub tryme()
MsgBox ActiveCell.Address
End Sub

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"kt(uk)" wrote in message
...
I would like to know if there is a macro command that will return the
position of the current activcell. This could either be in the format B6
or
6,2