Get reference to cell containing function

Question

Is there is way to access cell that contains my UDF? I need to reset some cache when function with same parameters is run from different cell. Didn't find anything suitable in exceldna utils.

Thanks, Alex

score 4 · Accepted Answer · answered Jun 12 '16 at 20:52

4

You can call

ExcelReference caller = XlCall.Excel(XlCall.xlfCaller) as ExcelReference;

The result will be an ExcelReference if you're called from a sheet formula. It might be null if you're called via Application.Run or a few other ways.

ExcelReference is a wrapper for the C API sheet reference.

answered Jun 12 '16 at 20:52

Govert

16,387
4
60
70

Thanks Govert. I'm using sheet formulas – Alex Michel Jun 12 '16 at 21:12
By calling `XlCall.Excel(XlCall.xlfCaller)` I always get `ExcelErrorRef {23}` - why? – johnnyontheweb Sep 20 '22 at 17:52

Get reference to cell containing function

1 Answers1