View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
SeaSparrow SeaSparrow is offline
external usenet poster
 
Posts: 1
Default 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