Results 1 to 2 of 2

Thread: Excel: limit to range names?

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    May 2004
    Location
    Right here
    Posts
    275

    Excel: limit to range names?

    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
    http://www.sudsolutions.com

  2. #2
    Addicted Member
    Join Date
    Jan 2006
    Location
    Montreal, Canada
    Posts
    152

    Re: Excel: limit to range names?

    I know that you can select a maximum of 2048 ranges.

    I do not see any other range limitation in the excel specification en limits help file

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width