Address of cell invoking current UDF call?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eddie - 23 Apr 2008 02:40 GMT

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.

Reply to this Message

Jim Cone - 23 Apr 2008 03:23 GMT

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.

Reply to this Message

Eddie - 23 Apr 2008 04:08 GMT

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

> Try out this udf...
> '--
[quoted text clipped - 19 lines]
> cell
> address "A1"?

Reply to this Message

Mark Ivey - 23 Apr 2008 03:25 GMT

Here is one option...

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

Mark Ivey

> 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
[quoted text clipped - 7 lines]
> Assuming, of course, that such a thing is possible. Thanks in advance.
> Larry.

Reply to this Message

Eddie - 23 Apr 2008 04:12 GMT

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.

> Here is one option...
>
[quoted text clipped - 17 lines]
>> Assuming, of course, that such a thing is possible. Thanks in advance.
>> Larry.

Reply to this Message