DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007
    Sterling Heights, Michigan

    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?

  2. #2
    Join Date
    Aug 2004
    Orange, California
    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
    Sterling Heights, Michigan
    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.

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
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.