Re: HyperLink issues ....

2015-02-26 Thread Alexander Hörnlein
if you define a new style for each link/cell then your sheet runs out of styles space, see if you can reuse the style aloha alexander Am 26.02.2015 um 01:41 schrieb mskavim: I am create a excel sheet( Bill of Material Report ) that has more that 2000 rows ... each row has hyper link to a

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