The behaviour of SubNm formulas changed slightly in FP1 of 9.4.1.
Prior to that version you could enter the syntax:
(That is, omitting the other arguments.)
Code: Select all
Double clicking on the cell would launch the subset editor. The other arguments would be populated when you selected an element from the editor.
In 9.4.1 FP1, using that syntax will result in an unhandled VBA error 13 (type mismatch) when the cell is double clicked.
Other SubNM formulas will not work after that happens until you press [F9] to recalculate the sheet.
This bug occurred when the function was changed to allow it to use cell references as arguments. Prior to 9.4.1 FP1, if you used a cell reference for, say, the server name, the double click functionality would not work. It does in FP1, but you must specify all of the arguments for the function.