Results 1 to 7 of 7

Recursive loop through the rows and columns

Threaded View

  1. #1
    Registered User
    Join Date
    09-22-2018
    Location
    russia
    MS-Off Ver
    2010
    Posts
    4

    Recursive loop through the rows and columns

    Hello everybody.
    Guys help me figure out the task please
    I have the following problem.

    I need to combine values from all columns and rows.
    At the beginning, we take the first value of the first column and append the first value of the second column to it
    Then we add all the values of the third column to the result.
    Then we take first value of the first column, append the second value of the second column and append all values from 3-rd column again.
    And so on.

    The example clearly shows what is required.

    The number of columns is variable
    The number of lines is different everywhere.

    I understand that this can be solved by a recursive function. I tried to write it, but I did not succeed at all. Full trash..
    Please help
    Attached Files Attached Files
    Last edited by maximusu; 10-11-2018 at 04:36 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Do Loop and recursive Dir(): How to separate the first match from all other matches in all
    By greenythebeast in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2016, 03:14 PM
  2. Loop Across Columns...If Blank Cell, Loop Down Rows
    By flindy87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2014, 07:05 PM
  3. Loop Across Columns If Blank Cell Loop Down Rows
    By flindy87 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2014, 10:22 AM
  4. Deal With Recursive (Endless Loop)
    By Oxco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-30-2013, 08:14 PM
  5. Replies: 1
    Last Post: 11-08-2012, 04:53 PM
  6. Calling a recursive Sub in a 'for' loop in another Sub
    By excelworker_1 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-15-2012, 10:57 AM
  7. Recursive Loop -- How to Stop It?
    By LarryP in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-28-2006, 03:50 PM

Tags for this Thread

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