ThisCell Property

A function called "UseThisCell" contains the ThisCell property to notify the user of the cell address.

Function UseThisCell()

    MsgBox "The cell address is: " & _
        Application.ThisCell.Address

End Function