Dave,

I agree that the number is not really not important. I was thinking that
there is some other rule operating, and that someone else might chime in
here with the real answer.

Thanks for hanging in there. :)

-Dennis


In article ,
Dave Peterson wrote:

How about you doing some testing and then post back with your results.

Personally, I'll never remember what that number is (as I've shown!). I just
remember that long strings cause trouble and know that I have to work around
them.

Do you actually think that you'll remember this exact number in a couple of
months? <vbg

dk_ wrote:

Come' on, someone must know the rule. ;)
Excel is not as generous as living with a rule that says, "298 or 256
whatever."

-Dennis

In article ,
Dave Peterson wrote:

298 or 256 -- what's the difference between friends? <vbg.



dk_ wrote:

Regarding the guess at a 256 character limit, that's not it. I just
checked. The range that works is 298 characters, and with code
surrounding the range it's 298 characters, and I could add one more
cell, for another 4 characters (and that was the limit).

There must be another rule operating that limits how a range can be
described.

-Dennis

--
Dennis Kessler
http://www.denniskessler.com/acupuncture

In article ,
Dave Peterson wrote:

I _think_ that the limit is 256 characters (or about that).
I usually keep adding until it breaks, then swear a little bit and go back to fix it.



--
Dennis Kessler
http://www.denniskessler.com/acupuncture