Which cell is calling a user-defined function?
 

I am writing a VBA function that may appear in multiple worksheet cells, and
may be entered as a array formula, {=MyFunc(input_range)}. How do I get the
address of the cell from which the function was called when the worksheet is
being recalculated?

Which cell is calling a user-defined function?
 

You can use: Application.caller


Randy in Calgary wrote:

I am writing a VBA function that may appear in multiple worksheet cells, and
may be entered as a array formula, {=MyFunc(input_range)}. How do I get the
address of the cell from which the function was called when the worksheet is
being recalculated?

--

Dave Peterson