where am I?

M

Mark Kubicki

is there a function that identifies what cell a formula is being used in?

ex; I have a formula: =LMI(xx) entered into cell B32 as part of the code
behind the formula, I need to know what cell the formula is being used in.

many thanks in advance,
mark
 
D

Dave Peterson

Do you mean within the code for the LMI user defined function?

If yes, you can use application.caller

Option Explicit
Function LMI(xxx as yyyy) as uuuu
debug.print application.caller
...
end function
 
R

Rick Rothstein

I'm assuming LMI is a UDF that you wrote and it is its code that you want to
have know which cell called it. You would use Application.Caller to return a
range object which references that cell.
 
T

Tim Zych

Here's a sample UDF using the Caller property:

' UDF which returns the address info of the cell
' in which it resides
Function Addr() As String
' Addr = Application.Caller.Address
' Or more detail
With Application.Caller
Addr = .Parent.Parent.Name & ", " & _
.Parent.Name & ", " & .Address(0, 0)
End With
End Function
 
Top