I have a custom function (B) which is stored as text in a named range. This named range is then referenced by custom function (A) from a worksheet cell. For the named range custom function (B), the cell object in the contextObjects parameter on the CalculateCustomFunction function is showing the cell reference of custom function A instead of B. This is incorrect as the source of calculation is not the worksheet function, but the function stored in the named range.
How can we determine that a formula is firing from a named range?
Please see attached archive for a sample.
AsposeNamedRangeIssue.zip (2.1 KB)