Doug,

Why would you ever want to create a name of 255 characters? That is not a
recipe for easy maintainability.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Doug Glancy" wrote in message
...
I don't seem to be able to Google a helpful answer on this, although I'm
sure it's been discussed a bunch. If I try to define a name in the Insert
Name dialog, it clears the "refers to" box after (I'm guessing) 255
characters and starts over. But if I define the name through code, the
range contains all the cells in the code even though they don't all show
in
the Insert Name "refers to" box.

So, what's the best way to create a named range that's longer than 255
characters? Will the range continue to include all the cells? It seems
to.

Thanks,

Doug Glancy