Re: Specified named range null/undefined does not exist in the current workbook.

2015-02-27 Thread Blake Watson
Nick-- What am I looking for? Are null/undefined/Empty supposed to be supported? ===Blake=== On Thu, Feb 26, 2015 at 8:34 PM, Nick Burch apa...@gagravarr.org wrote: On Thu, 26 Feb 2015, Blake Watson wrote: I got this error evaluating a cell--which was a big old chained IF that return null

Specified named range null/undefined does not exist in the current workbook.

2015-02-26 Thread Blake Watson
I got this error evaluating a cell--which was a big old chained IF that return null at one point and undefined at another, and I think I found two fixes for it: I replaced the null with Empty. I defined a named ranged called null and used that in place of the undefined. For experimental purposes

Re: Specified named range null/undefined does not exist in the current workbook.

2015-02-26 Thread Blake Watson
Wait, I was mistaken. Empty does not work. Using a named range called null works, of course, though I'm not sure of the implications thereof. On Thu, Feb 26, 2015 at 3:03 PM, Blake Watson blake.wat...@pnmac.com wrote: I got this error evaluating a cell--which was a big old chained IF that

Re: Specified named range null/undefined does not exist in the current workbook.

2015-02-26 Thread Nick Burch
On Thu, 26 Feb 2015, Blake Watson wrote: I got this error evaluating a cell--which was a big old chained IF that return null at one point and undefined at another, and I think I found two fixes for it: Can you produce a junit unit test which starts with an empty workbook, adds a sheet and