I have a UDF that checks for the existence of a comment. I use this in CF because I want to colour a cell if 1. The cell is not blank and 2. There is no comment. This has worked just fine with 2007 and 2010 but now I have 2016 and Excel has gone a little bit weird on me.
Now when I meet the criteria, the formatting is applied and then goes away again. If I disable Automatic Calculation it behaves normally, until I recalculate. I also get errors upon saving the document. 'Calculation is incomplete...'.
Does anybody know a fix I can apply to my many workbooks I have that use this CF? Did something change in the 2016 Excel offering?
Any help would be greatly appreciated.