Thanks, Mark. This works for the active cell, but a cell calling a user
defined function may not necessarily be the active cell -- which Jim's
solution gets at. But I still appreciate the help.

Gotta love these help groups. Seldom fail to find people willing to help
out.

"Mark Ivey" wrote in message
...
Here is one option...

Sub GetCurrentAddress()
Dim myCell As String
myCell = ActiveCell.Address
MsgBox myCell
End Sub


Mark Ivey

"Eddie" wrote in message
...
I would like to write a user defined function that, as part of its
execution, needs to know the cell address from which it is currently
called. I.e. if
cell A1
= UDF(parm1, parm2)
then,
what type of statement can I use in the UDF to return the executing
cell address "A1"?

Assuming, of course, that such a thing is possible. Thanks in advance.
Larry.