+ Reply to Thread
Results 1 to 6 of 6

Join Arrays

  1. #1
    Forum Contributor
    Join Date
    09-08-2014
    Location
    Toronto, Canada
    MS-Off Ver
    2007
    Posts
    122

    Question Join Arrays

    Hi Experts, I am stuck please provide some help.


    I have 3 string arrays(see below) that i would like to join in order to reference using cells.
    Example newarray(2,3) should return "Body C".

    Please help.


    Please Login or Register  to view this content.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Join Arrays

    Hi,

    What do you mean by "to reference using cells"?

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Join Arrays

    Please Login or Register  to view this content.

  4. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Join Arrays

    You need to do a loop like

    Please Login or Register  to view this content.
    VBA is lacking in methods for bulk dealing with arrays.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  5. #5
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Cool

    Hi !

    Another way :

    PHP Code: 
    Sub Demo()
        
    VA = [{"Title A","Title B","Title C";"Body A","Body B","Body C";10,20,30}]
        
    MsgBox VA(23)
    End Sub 
    Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !

  6. #6
    Forum Contributor
    Join Date
    09-08-2014
    Location
    Toronto, Canada
    MS-Off Ver
    2007
    Posts
    122

    Re: Join Arrays

    Thank you all for your help, all 3 solutions work 100%. I will make good use of them.

+ 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. Join arrays in Excel
    By coldmejl in forum Excel General
    Replies: 2
    Last Post: 03-19-2014, 04:28 AM
  2. [SOLVED] SQL Join - Left Join, but with 4 tables
    By kenny.fsw in forum Access Tables & Databases
    Replies: 4
    Last Post: 05-29-2013, 09:03 AM
  3. Join two arrays =ArrayOut(ArrayIn1, ArrayIn2) via a UDF in Excel.
    By olasa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2012, 06:05 AM
  4. Join large Arrays
    By matrex in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-02-2012, 03:22 AM
  5. Reorder elements a cell using arrays, split & join
    By k8_dog in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-12-2011, 01:58 PM
  6. How to merge/join/append/concatenate VBA arrays
    By macyarab in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2009, 04:21 AM
  7. [SOLVED] Arrays and Join Function
    By Stefano Condotta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2006, 07: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