+ Reply to Thread
Results 1 to 4 of 4

How to Populate a two dimensional array with text

  1. #1
    Forum Contributor
    Join Date
    06-24-2006
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    127

    How to Populate a two dimensional array with text

    Hello all,

    Can someone tell me where I am going wrong.

    I want to populate a two dimensional array with firstly some text and the secondly the activecell.address

    I keep getting an error message saying syntax error. My code is below:

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: How to Populate a two dimensional array with text

    Hope you can figure out the problem..

    Please Login or Register  to view this content.
    if not let us know..
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Forum Contributor
    Join Date
    06-24-2006
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    127

    Re: How to Populate a two dimensional array with text

    Thanks for your reply. However I want the array to be populated in order. What I mean by this is that error_log(0,0) comprises of "Missing Data" and the Activecell.address and then the next array error_log(1,1) will have the next pair of data. Does that make sense?

  4. #4
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: How to Populate a two dimensional array with text

    Hi Jims..

    then the next array
    just want to tell you.. after Array(0,0) next array is array(0,1)..

    you are putting item in a single box..
    error_log(x, x) = ("Missing Data", activecell.Address)

    By this line you are creating a container.. with 1000 x 1000 box
    where box are like..

    0,0 0,1
    1,0 1,1
    ... ...
    ... ...
    999,998 999,999

    in 1st box.. you are putting forcefully.. two item..

    re-read the array concept.. please come again.. if you are facing any problem..

+ 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. [SOLVED] List most common text values from a two-dimensional array
    By alienss in forum Excel General
    Replies: 2
    Last Post: 10-11-2012, 09:53 AM
  2. Populate a Single Dimensional Array with two Dim Array (matrix)
    By Benjamin1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-03-2011, 12:49 PM
  3. Creating a 2-dimensional array from a 1-dimensional list
    By guywithcamera in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-27-2008, 06:34 PM
  4. [SOLVED] Populate list box with multi-dimensional array
    By Graham Whitehead in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-10-2006, 07:30 AM
  5. [SOLVED] Create One-Dimensional Array from Two-Dimensional Array
    By Stratuser in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2005, 05:06 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