Can you bulk add Named Ranges?
Results 1 to 4 of 4

Thread: Can you bulk add Named Ranges?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Feb 2014
    Posts
    2,264
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Can you bulk add Named Ranges?

    Hi Everyone,
    I have list of about 3000 names down column A that are the names for each range,
    every range needs to be "The row the names in" Columns C:Y"

    is there a macro or easy way to do this without adding them all manually?

    thanks

    Tony

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    25,330
    Post Thanks / Like
    Mentioned
    439 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Can you bulk add Named Ranges?

    Would it matter is col B was also in the named range?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    1,750
    Post Thanks / Like
    Mentioned
    26 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Can you bulk add Named Ranges?

    May I ask why do you need so many named range?
    Is it for the source of data validation?
    If yes then actually you can use vba and use just one named range to do the job.

  4. #4
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    9,127
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Can you bulk add Named Ranges?

    it is easy if the names and data are contiguous. best to save the file first

    so, if you can temporarily put the names in column B
    then select from B1:Yzz
    then CTRL-SHIFT-F3
    left column (ALT-L)
    and return

    then move back to column A the data that was temporarily in B
    If you've posted a clearly explained question & sample data - both input & corresponding output - that can be copied to Excel, THANK YOU.
    Google can find answers to nearly every question.


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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