poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Blake Watson <blake.wat...@pnmac.com>
Subject Specified named range null/undefined does not exist in the current workbook.
Date Thu, 26 Feb 2015 23:03:50 GMT
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/>

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