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