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.

--
Rick (MVP - Excel)


"Mark Kubicki" wrote in message
...
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