What is "my" cell?
Yes. Application.Caller.Address will give the cell containing the function
and
Application.Caller.Parent.Name will give the Worksheet name.
Josh Sale wrote:
Is there a way for a user defined function to tell what cell its being run
from?
For example if cell C3 is set to =MyUDF("x") is there a way for MyUDF to
figure out that its running from C3?
TIA,
josh
|