where am I?

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
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
 
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
 
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.
 
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
 
Back
Top