The limit in the Define Name dialog's Refers To box is 255 characters. So
the number of areas a name created using it can have depends on their
addresses and the length of the sheet's name.

--
Jim
"Bagia" wrote in message
...
| Hello,
|
| I hope someone can help me solve this problem. What is the limit on how
| many non adjacent cells/ranges can be saved in a Named Range? Sometimes MS
| Excel 2003 will allow me to have 16 non-adjacent cells and other times it
| will let me do just 11.
|
| Thank you.