+ Reply to Thread
Results 1 to 2 of 2

Variable Cell Range

  1. #1
    Registered User
    Join Date
    09-26-2008
    Location
    Burlington
    Posts
    2

    Variable Cell Range

    Is there any way to define a 'variable' cell range?

    For example, I have created a drop-down box using Data Validation and defined a cell range for options to appear in the drop-down box. The problem is I want to be able to add items onto the end of the cell range and have them appear as new options in the drop-down box WITHOUT having to redefine the cell range in the Data Validation dialog.

    So far the best i've got is to simply define the cell range as the ENTIRE column where the list of options is located. When i add new items to the bottom of my list they DO appear in the drop-down box, however a lot of unwanted blanks appear aswell.

  2. #2
    Registered User
    Join Date
    09-26-2008
    Location
    Burlington
    Posts
    2
    Found a solution: http://www.contextures.com/xlNames01.html#Dynamic

+ 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. copy a range of cell values to another range of cells if one cell = 1
    By jamiepullen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2008, 10:26 AM
  2. Replies: 1
    Last Post: 07-17-2008, 01:21 PM
  3. Update time when cell in range changes
    By kvfhg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-12-2008, 05:29 PM
  4. Define variable range as named range
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2008, 09:28 AM
  5. AutoFill, can the last cell in range be variable?
    By AdamParker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-02-2008, 04:09 PM

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