View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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