Address of cell invoking current UDF call?

[Eddie]

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.

 

[Jim Cone]

Try out this udf...
'--
Function Sludge()
Sludge = Application.Caller.Address
End Function
'--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"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.

 

[Mark Ivey]

Here is one option...

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


Mark Ivey

 

[Eddie]

Exactly what I need. And simple to boot. Thanks!!

 

[Eddie]

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.