Results 1 to 9 of 9

Multi-Dimensional concatif coding

Threaded View

  1. #8
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Multi-Dimensional concatif coding

    Okay I guess I have been able to achieve it.
    Next time, be sure that you provide a sample workbook so that we don't have to create it ourselves.

    Here is the revised JoinC code, I have revised it in the post2 as well.

    Function JoinC(ByRef x As Variant, ByRef Delim As String) As String
        '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
        '           Developed by Vikas Gautam                               '
        '         Forum Expert at ExcelForum.Com                            '
        'For Concatenating Arrays or Ranges having One Row and Many Columns '
        '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
        dLen = Len(Delim)
        With Application
            SourceArray = .Transpose(.Transpose(x))
            Delim2 = Delim & Delim
            Temp = Replace(Join(SourceArray, Delim), Delim2, Delim)
            
            Do While InStr(1, Temp, Delim2, 1) > 0
                Temp = Replace(Temp, Delim2, Delim)
            Loop
        End With
        
        If Left(Temp, dLen) = Delim Then Temp = Mid(Temp, dLen + 1, Len(Temp))
        If Right(Temp, dLen) = Delim Then Temp = Left(Temp, Len(Temp) - dLen)
        JoinC = Temp
    
    End Function
    Check the attached file:-
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Multi-dimensional VLOOKUP
    By LadyS in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-25-2014, 12:37 PM
  2. [SOLVED] Dim multi dimensional array
    By jdfjab in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-06-2012, 09:08 AM
  3. Multi-Dimensional Arrays
    By ajocius in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-09-2009, 11:20 AM
  4. Multi Dimensional Array
    By andym in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-10-2006, 03:29 AM
  5. Multi-Dimensional Array Let & Get
    By Trip in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2005, 04: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