+ Reply to Thread
Results 1 to 2 of 2

Name range that will change size multiple ranges

  1. #1
    Registered User
    Join Date
    05-20-2013
    Location
    Boston
    MS-Off Ver
    Excel 2010
    Posts
    38

    Name range that will change size multiple ranges

    I have multiple ranges seperated by a blank row. I want to name each range to use in a formula. The ranges will change when I insert new rows. I want to name each range I3:I22 as Hrs1, K3:K22 as Cost1, then I24:I39 as Hrs2 and K24:K39 Cost2. Then if I add two invoices to my first named range, I want the range to expand to have Hrs1 be I3:I24, Cost1 be K3:K24, Hrs2 to be I26:I41, Cost2 to be K26:K41 etc. I'll attach my example.
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Name range that will change size multiple ranges

    You cannot use Hrs1 and Hrs2 as range names, because they are valid cell addresses, i.e., HRS1 is a cell.

    Anyway, what you're describing is automatic. If you set up those ranges, then insert or delete rows, Excel will update them all automatically to reflect the change. Have you tried it?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. How to change X axis range using dynamic ranges
    By james444 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-12-2013, 04:23 PM
  2. [SOLVED] Change Size of Multiple Comments
    By dompoma in forum Excel General
    Replies: 15
    Last Post: 04-12-2013, 01:46 AM
  3. Change Size of Multiple Cell Comments Simultaneously
    By dompoma in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2013, 11:33 PM
  4. [SOLVED] How to select and delete a range of cells between two different ranges of unequal size?
    By herbie226 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-08-2012, 04:40 PM
  5. Change Multiple ranges in one go
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2007, 10:47 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