What is "my" cell?
 

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

What is "my" cell?
 

Application.Caller

Sorry for the unnecessary posting!

josh

What is "my" cell?
 

You can also use

Application.ThisCell

This differs from Application.Caller when used in array formulas.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Josh Sale" <jsale@tril dot cod wrote in message
...
Application.Caller

Sorry for the unnecessary posting!

josh

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

What is "my" cell?
 

Thanks Chip.



"Chip Pearson" wrote in message
...
You can also use

Application.ThisCell

This differs from Application.Caller when used in array formulas.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Josh Sale" <jsale@tril dot cod wrote in message
...
Application.Caller

Sorry for the unnecessary posting!

josh