Forum Discussion
Error message _xlfn.SINGLE
mtarler Unfortunatelly I only saw and read this message today. I will try it now.
LCSALLES985 Unfortunatelly your sugestion did not work.
Also unfortunatelly I am not finding more messages sent by me and answeered by the community in the past 2 days. Can you direct me to where they are?
Possible scenario is that formula was created on Excel with dynamic arrays, after that file was opened in Excel without dynamic arrays. That could be same your Excel if you are on semi-annual channel - during the DA deployment for this channel in July this year DA disappeared for a while. To my knowledge now the issue is fixed and semi-annual shall be fully on DA. Or it was opened on another computer.
You may safely remove _xlfn.SINGLE. If you are with DA (to check start typing =SORT if available or not, or any other such function, but with name for your locale. Or simply type in any empty cell =A1:A9 and check if it returns an array or not) nothing to do more. If not, you may enter it as array formula with Ctrl+Shift+Enter or change _xlfn.SINGLE on @. Result will be different, but I'm not sure which one shall be.
LCSALLES985 As I mentioned before, it appears there is something with your defined names. can you attach a copy of the actual workbook? As for recent messages, all I see was my message followed by your messages today.
