+ Reply to Thread
Results 1 to 5 of 5

Named ranges-Should I use a dynamic named range

  1. #1
    Registered User
    Join Date
    06-08-2009
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2007
    Posts
    17

    Named ranges-Should I use a dynamic named range

    Hi. I have a spreadsheet with a named range covering one range in a column and another named range covering the same range of cells in the next column. I also have a named range for a lookup area covering the same cells in both of the columns. I'm running a macro that add cells to the middle of both of the two named ranges and they both expand to cover the whole area but the lookup range is not expanding.

    Anyone have any ideas why? Should I use a dynamic named range or should I just cover the whole of both of the columns for the lookup rather than the two named ranges?

    Thanks

    Foseco

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,669

    re: Named ranges-Should I use a dynamic named range

    How are the ranges defined?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-08-2009
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2007
    Posts
    17

    re: Named ranges-Should I use a dynamic named range

    I just selected the cells that cover the data and named each range. Then when I wanted to setup the lookup range I did the same for the cells I wanted to lookup. I have now changed my lookup range to cover 10000 cells of both of the columns as there will never be that much data in the two columns but there must be a tidier way.

    Is that what you meant?

    Foseco
    Last edited by foseco; 06-11-2009 at 03:54 PM.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,669

    re: Named ranges-Should I use a dynamic named range

    ... but there must be a tidier way.
    A whole new world awaits you. Google excel dynamic named ranges. Every hit on the first page is gold.

  5. #5
    Registered User
    Join Date
    06-08-2009
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2007
    Posts
    17

    re: Named ranges-Should I use a dynamic named range

    Thanks for the advice I suspected that would be the case.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1