Hello,
i am looking for a looping VBA code that loops through a 2 dimensional array...lets say with 9 rows and 17 columns (label name Area1)....i would like to designate the character number to start (like start at the first character) then to skip x amount of characters and print the character in between the skipped characters....then start with the next character after the printed character and so forth...looping until the number of character print is completed (9x17 = 153 characters max) i would like the characters printed in the same array size (9x17). next to area1.
Enter start point, enter skip amount
loop through the array and print next value
I have attached an image example.
thanks in advance!
Rene
i am looking for a looping VBA code that loops through a 2 dimensional array...lets say with 9 rows and 17 columns (label name Area1)....i would like to designate the character number to start (like start at the first character) then to skip x amount of characters and print the character in between the skipped characters....then start with the next character after the printed character and so forth...looping until the number of character print is completed (9x17 = 153 characters max) i would like the characters printed in the same array size (9x17). next to area1.
Enter start point, enter skip amount
loop through the array and print next value
I have attached an image example.
thanks in advance!
Rene