EXCEL VBA: Why is it not possible to call a UDF, which contains anywhere Application.Evaluate(), with Application.Evaluate()?
It took me some time to figure out that it is not possible use the Application.Evaluate() function with a user defined function which contains also Application.Evaluate(). See the code example below.