There's a handful of hidden names in my workbook that are killing my attempt to use VBA to copy 200+ Named Ranges to a new workbook. One of them is named "_xlfn.IFERROR" -- it doesn't show up in Excel's native Name Manager, but the Name Manager 4.3 add-in DOES show it (b/c it has the ability to show 'hidden' names).
I googled _xlfn.IFERROR and pages seemed to suggest that it was caused by trying to use an earlier version of Excel (which didn't support the function you used when creating the file in a later version.)
But that doesn't apply here at all. In fact, that hidden/erroneous range is getting created immediately even in a new 2007 workbook as soon as I type a new =IFERROR formula. E.g.:
i) I open a completely blank workbook
ii) I type in a very basic IFERROR formula in A1
iii) And then I open the Name Manager add-in that shows the below.
That makes no sense. 2007 does support IFERROR, and the formula is calculating correctly...but that _xlfn.IFERROR hidden/erroneous range is getting created anyway. Why?
I googled _xlfn.IFERROR and pages seemed to suggest that it was caused by trying to use an earlier version of Excel (which didn't support the function you used when creating the file in a later version.)
But that doesn't apply here at all. In fact, that hidden/erroneous range is getting created immediately even in a new 2007 workbook as soon as I type a new =IFERROR formula. E.g.:
i) I open a completely blank workbook
ii) I type in a very basic IFERROR formula in A1
iii) And then I open the Name Manager add-in that shows the below.
That makes no sense. 2007 does support IFERROR, and the formula is calculating correctly...but that _xlfn.IFERROR hidden/erroneous range is getting created anyway. Why?
