For a time I use an UDF which is similar to LAMDA function, where the input formula is a string. This works always without any issue. Within the UDF the function string is processed with the Excel EVALUATE function and returns the correct result for single and array values too. But now I have a formula which is longer than 255 character natively. Reserch results advise to set an unused cell via the UDF implicitely with the formula, calculate it and obtain the result for further processing. Now this works with the long formulas too, but the issue is that if the formula returns an array (as an array function), the formula should be also an array formula in the cell (curly braces wrapped). This is what I couldn’t achieve.