Copy 1 Cell Data Into Next Column

Really easy problem help please:

So I have a column say from A1-AXX of data with commas separating them.

So Ex:

A1 cell has data: "1,2,3,4,5,6,7,8"

A2 cell has data: "1,2,3,4,5,6,7,8"

Now I want the data split from:
A1 put into next B1,C1,D1,E1... until all the comma seperated data has been filled.
A2 into B2,C2, D2, E2 ..... etc

.... until all data has been entered.

I know its suppose to go something like (logically):

Select all column data A1-AXX as Integer = i (in this case the the columns)
for ( new x; x < AXX ; x++ )
{
split (Ax, ",") = str
Now put each value into the same row

move onto next column
}

etc..

I know this can be easily done with delimiter or whatever the option is but I wanna do it in vba macro :P cause I'm learning and I can't figure out how to use Ubound Lbound resize so please help :D

Originally Posted by rockell

I know this can be easily done with delimiter or whatever the option is but I wanna do it in vba macro :P cause I'm learning and I can't figure out how to use Ubound Lbound resize so please help :D

..... still need help :P