Hi Skydiver,

I didn't actually know about the limits. From reading the help file
it appears the 255 characters limit applies to the name itself, not
the range.

With a bit of trial and error it seems that 46 is the limit of cells
that you can put in one range whether they are empty or
populated.

You could split your range into 3 ranges which is a bit clumsy
I guess, but still, better than nothing.

HTH
Martin