Sheet names can have only 31 characters in current versions of XL. 255
is just a large number to ensure that all characters in the sheet name
are captured. You could use 31 if you wanted, but future versions of XL
might not work.

My personal use of 255 comes from writing assembly language programming.
255 is (2^8 - 1), or the largest integer that can be stored in an 8-bit
byte.


In article <LACA.2864bz_1148232602.5095@excelforum-nospam.com>,
LACA <LACA.2864bz_1148232602.5095@excelforum-nospam.com> wrote:

> What is the significance of 255? Is that the limit for number of
> characters the formula will look at? Could I use 355 and get a
> different result, if the string had that many characters?