Excel VBA - Resize List (At Least That Is What I Think I Need)


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Excel VBA - Resize List (At Least That Is What I Think I Need)

  1. #1
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666

    Excel VBA - Resize List (At Least That Is What I Think I Need)

    I have a list that is set to a defined range in the one spreadsheet.

    I need to add a new rows to this list, so after doing so, I figured what I would need to do in order to add the new rows to the existing list was Data/List/Resize List

    The problem is Resize List is disabled.

    So, if I have a List named "Hack" which goes from A1:B42 and I need to add three rows and now need "Hack" to go from A1:B45, how do I do that?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  2. #2
    Join Date
    Aug 2004
    Location
    Orange, California
    Posts
    1,261
    All you need to do is to insert the new rows just before the last entry in the existing list.
    This will expand the list automatically. If you need the new items at the end of the list then move the value of the last item back up to the first new row then just set the new values in the bottom rows.

  3. #3
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Actually, I stumbled across an article which lead me to believe that I'm not really dealing with a list, but with a named range.

    After adding what I needed to add, I did: Insert/Name/Define - then I selected the appropriate range name, and extended the end range accordingly.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

Similar Threads

  1. Replies: 3
    Last Post: 07-14-2008, 08:13 AM
  2. Replies: 0
    Last Post: 05-15-2008, 04:24 PM
  3. Replies: 1
    Last Post: 01-02-2007, 08:58 AM
  4. Workbook not Closing Properly by Excel VBA
    By blayne in forum VB Classic
    Replies: 1
    Last Post: 11-17-2005, 06:14 PM
  5. Excel, VBA, SQL, DAO 3.6 help needed
    By Jared Evans in forum VB Classic
    Replies: 2
    Last Post: 05-29-2003, 04:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center