Please fix the automation error for user defined formulas in tables
I have a simple table(=listobject) with a UDF in it, something like this:
Public Function TestUDF(varTest As Variant, rngZZTest As Range) As String
TestUDF = rngZZTest.Value & varTest
Now I save the workbook in Excel 2016 and open it in Excel 2013 (32Bit). Excel jumps into the VBA editor, highlightes the UDF and an error occurs: "Compile error: automation error" (without any error number). I can compile the code and save it in Excel 2013, then the error message disappears. But always if I save the workbook in Excel 2016 and open it in Excel 2013, the error message is back!
I can open the workbook without any problems in Excel 2016, 2010 and 2013 (64Bit).