A range object contains a lot of information including the value, the
address, and formating. If you want the address then use the following

MsgBox = "You are currently in Cell " & ActiveCell.address


"Ronio" wrote:

I'm confused, the help file states that ActiveCell would return the range
object.

However, when I call ActiveCell , I"m getting the value of the cell not the
range??

MsgBox = "You are currently in Cell " & ActiveCell

How can I return the Cell that is currently selected?

Ron