Named Range Limitations
Maybe you can try this:
Select your range (click and ctrl-click as much as necessary)
Type the name in the name box (to the left of the formula bar)
(remember to hit enter when you're done)
If that doesn't work, one more test.
Select your range again
hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window
type this:
Selection.name = "TheNameYouWantToUseHere"
Then back to excel to test it out.
Bagia wrote:
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.
--
Dave Peterson
|