View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
dk_ dk_ is offline
external usenet poster
 
Posts: 70
Default Range selection rule?

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.