Posted 22 September 2022, 8:01 pm EST
I am trying to create a custom function which need to be aware of its execution context.
By using isContextSensitive and returning true I can get a context object during the evaluation which contains de cell coordinates.
However, in my case I also need the sheet or at least a mean to find it (name or index).
For the moment the only way I could think of was adding a field to my function with the sheet name and adding the function to each worksheet.
Ideally I would like to be able to instantiate the function once on the workbook level and getting the sheet from the context.
Is their a proper way to do it?