Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address of cell invoking current UDF call?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address of cell invoking current UDF call?
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address of cell invoking current UDF call?
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address of cell invoking current UDF call?
Exactly what I need. And simple to boot. Thanks!!
"Jim Cone" wrote in message ... 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"? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address of cell invoking current UDF call?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Column above current cell dynamically using function call | Excel Worksheet Functions | |||
Get Address of Current Cell | Excel Programming | |||
How do I call current computer time to a cell? | Excel Worksheet Functions | |||
use current cell address as beginning of macro | Excel Discussion (Misc queries) | |||
Cell address of function call | Excel Programming |