+ Reply to Thread
Results 1 to 2 of 2

Filling a MultiDimensional Array Row for Row

  1. #1
    Registered User
    Join Date
    05-23-2013
    Location
    switzerland
    MS-Off Ver
    Excel 2010
    Posts
    9

    Filling a MultiDimensional Array Row for Row

    Hey

    Is it possible to fill only one row of a multidimensional array with a defined Dimension.

    Please Login or Register  to view this content.
    I have the Arrays aCC and aE and would like to store them in one row of aLabAssignement in Column "k")
    So i would end up with a fully filled Array after the for Loop.
    Is there a method how i can fullfill this without another for loop just filling in every value on it's own?

    Thanks for your Answers
    Last edited by Guesty; 08-08-2013 at 10:17 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Filling a MultiDimensional Array Row for Row

    You should have posted your entire code and workbook. The extracts provided don't make any sense as they stand.
    * You are using the ReDim keyword to declare the arrays so the variables iCCAmount, iEAmount, iCCUpperLimit and iEUpperLimit must be initialized elsewhere.
    * By using the ReDim with out the Preserve keyword, you are resetting the elements of the arrays to zero three times in your For..Next loop
    Ben Van Johnson

+ 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. Using the ReDim array function in a multidimensional array in excel
    By Doruli in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-05-2012, 01:43 PM
  2. Row copy within multidimensional array
    By guptaraja in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2010, 10:48 PM
  3. Multidimensional Array
    By sidd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2009, 09:57 PM
  4. Multidimensional array
    By gwithey in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 02-02-2009, 12:15 PM
  5. Syntax for multidimensional array
    By Arne Hegefors in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2006, 01:25 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