13 reputation
3
bio website
location
age
visits member for 2 years, 2 months
seen Oct 19 '12 at 6:59

Oct
18
comment How to split cell in a row with Excel
is there a way to split up two or more column with the same number of line ? I tried to add a loop but it doesn't work as I expected.
Oct
12
awarded  Editor
Oct
12
revised How to split cell in a row with Excel
added 2935 characters in body
Oct
12
comment How to split cell in a row with Excel
I've tried to add this line after 'set A,B,C -> arrSum(3, UBound(arrSum, 3)) = arr(i, 3)
Oct
12
comment How to split cell in a row with Excel
Thanks again. Do you have an idea how could I add in the array more columns after the letters (A, B, C, D ...) ?
Oct
12
awarded  Scholar
Oct
12
accepted How to split cell in a row with Excel
Oct
12
comment How to split cell in a row with Excel
Thanks a lot for your code sample. It works perfectly with my example. My real spreadsheet have 10 colums and around 3500 rows, I will try to adapt your code. How could I write the result array in a new sheet ?
Oct
11
awarded  Student
Oct
11
asked How to split cell in a row with Excel