Which cell is calling a user-defined function?

R

Randy in Calgary

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?
 
D

Dave Peterson

You can use: Application.caller

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?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

user defined function which increase consecutively while passingbelow cells 12
index function in vba 4
Problem with SET & REF function 0
User Defined Function 5
User defined function 10
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Cell reference in User Defined Function. 19
User Defined Function being called by changes to an independent workbook 13

Top