Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I Assign A User Defined Function To A Cell? | Excel Worksheet Functions | |||
calling a user defined add-in | Excel Programming | |||
Calling Excel user defined function from C# | Excel Programming | |||
Calling user defined function from C/C++ | Excel Programming | |||
current cell in user-defined function | Excel Programming |