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.

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.

Here is one option...

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


Mark Ivey

"Eddie" <(E-Mail Removed)> wrote in message
news:7E22E92F-193B-4FE7-A0ED-(E-Mail Removed)...
> 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.
>
>

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

"Jim Cone" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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"?

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" <(E-Mail Removed)> wrote in message
news:486C3443-5EC6-4409-AEFD-(E-Mail Removed)...
> Here is one option...
>
> Sub GetCurrentAddress()
> Dim myCell As String
> myCell = ActiveCell.Address
> MsgBox myCell
> End Sub
>
>
> Mark Ivey
>
> "Eddie" <(E-Mail Removed)> wrote in message
> news:7E22E92F-193B-4FE7-A0ED-(E-Mail Removed)...
>> 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.
>>
>>