+ Reply to Thread
Results 1 to 2 of 2

Help converting one-dimensional array to multi-dimensional array

  1. #1
    Registered User
    Join Date
    09-23-2014
    Location
    Washington, DC
    MS-Off Ver
    2011
    Posts
    92

    Help converting one-dimensional array to multi-dimensional array

    Hi all,

    I have the following bit of code that works well for populating a one-dimensional array, but I'd like to have it be multi-dimensional to grab a bit more data. I'm mostly hung up on how this affects ReDim Preserve. I know I need to add another loop, but not sure where it should go.

    Thanks for your help!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Help converting one-dimensional array to multi-dimensional array

    See here:
    http://www.excelforum.com/showthread...t=#post4500765
    and here
    http://www.excelforum.com/tips-and-t...e-byvalue.html




    Alan
    ( and please respond to the answers you get, and mark your Threads as Solved when you are satisfied with the answers you get )
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

+ 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. Parse Data from one dimensional array into a 2 dimensional array.
    By JapanDave in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-30-2016, 07:29 AM
  2. Set up a multi-dimensional array
    By penfold1992 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-04-2013, 04:28 AM
  3. [SOLVED] Dim multi dimensional array
    By jdfjab in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-06-2012, 09:08 AM
  4. Populating a multi-dimensional array
    By Christian411 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-28-2008, 03:00 PM
  5. [SOLVED] Multi Dimensional Array
    By andym in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-10-2006, 03:29 AM
  6. Multi-Dimensional Array Let & Get
    By Trip in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2005, 04:05 PM
  7. UBound of multi-dimensional array?
    By paulharvey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2005, 02:05 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