Forum Discussion
Error message _xlfn.SINGLE
I have been using the old logical functions if, and,or. They are accepted when inserted but after being filed, they show up with this error message that does not help me anyway given that the functio...
LCSALLES985 unfortunately I'm having problems reading your formula due to translation issues but try using ctrl-shift-enter. Some of these legacy formulas handled arrays different than the new excel and so excel apparently has 'flagged' your formula as such.
Sorry for my English. Thank you and I will be back in a couple of hours.
LCSALLES985 your English was fine, it was just the formula itself that didn't translate, but from what I can interpret it appears you have a number of named ranges you are referencing and that is what Excel is having issue with. Are those named ranges single cell or ranges or dynamic? Did using ctrl-shift-enter fix the problem?
mtarler Unfortunatelly I only saw and read this message today. I will try it now.
LCSALLES985 Unfortunatelly your sugestion did not work.