poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Blake Watson <blake.wat...@pnmac.com>
Subject Re: Specified named range null/undefined does not exist in the current workbook.
Date Thu, 26 Feb 2015 23:08:34 GMT
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.watson@pnmac.com>
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:
>
> I replaced the null with Empty.
> I defined a named ranged called "null" and used that in place of the
> undefined.
>
> For experimental purposes only. I'm not sure how I'll ultimately handle
> this.
>
> Just curious if anyone has run into either of these, and how they handled
> it.
>
> --
>
> *Blake Watson*
>
> *PNMAC*
> Application Development Manager
> 5898 Condor Drive
> Moorpark, CA 93021
> (805) 330.4911 x7742
> blake.watson@pnmac.com <melanie.petrosyan@pnmac.com>
> www.PennyMacUSA.com <http://www.pennymacusa.com/>
>



-- 

*Blake Watson*

*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com <melanie.petrosyan@pnmac.com>
www.PennyMacUSA.com <http://www.pennymacusa.com/>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message