Distribute Text, then Drop to Next Line

I'm trying to make a vb script that takes text from column A, spits it to 4 columns on the same row, then goes to the next row, until there is no data. My problem is I don't know how to tell the TextToColums part of the script to go to the next line, as well.

Here is the code

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Hi talkinggoat

Obviously this hasn't been tested but I've adapted code I've used before to what it appears you're requesting:

Please Login or Register  to view this content.

Let me know if I can help.

John