+ Reply to Thread
Results 1 to 2 of 2

Create two dynamic named ranges in the same column?

  1. #1
    Forum Contributor
    Join Date
    12-29-2012
    Location
    usa
    MS-Off Ver
    Excel 2016
    Posts
    325

    Create two dynamic named ranges in the same column?

    So on one sheet I have two tables. The tables start in column B. Currently, Table 1 starts at row 9 and goes to row 38. Table 2 starts at row 43 and goes to row 70. The ranges need to be dynamic because x amount of rows will be added to Table 1.

    Any ideas on how I can have a dynamic named range for the row length in Table 1 and Table 2?

    Thanks.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,055

    Re: Create two dynamic named ranges in the same column?

    Use a reference to the structured name of the (bit of) the column. See example attached.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Quickly Create 100+ Dynamic Named Ranges
    By dharmon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2016, 05:13 PM
  2. Replies: 3
    Last Post: 01-14-2015, 05:22 AM
  3. Create new column with named dynamic range in VBA
    By BianchiBoy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2014, 06:31 AM
  4. [SOLVED] Create Multiple Dynamic Named Ranges with a Macro
    By bennank in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2012, 12:55 PM
  5. [SOLVED] Using named ranges to create dynamic charts in Excel 2003
    By BNCOXUK in forum Excel General
    Replies: 2
    Last Post: 11-01-2012, 10:59 AM
  6. [SOLVED] How to create multiple Dynamic Named Ranges at once? and Limit in excel 2010
    By vishnu01445 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-31-2012, 09:28 AM
  7. [SOLVED] Can you create dynamic named ranges containing array formulas?
    By Marie J-son in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2006, 09:10 AM

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