Hi,

Is there a limit to the number of ranges in Excel that can have user-defined names? (That is, names I would give to cells/ranges by selecting them and then entering the name in the Name Box).

I am creating a spreadsheet that may end up with many hundreds of named ranges and I want to find out if there is a limit before I go ahead and try to create this many named ranges.

Thanks
-Rob