delimited text to column in a loop

[DFrank231]

for this code, i am trying to insert three rows between columns D and E, and then filling those columns with delimited data in column D. here is what my data looks like before running this macro (http://i.imgur.com/kpIo7.gif), and here is what i want it to look like after: (http://i.imgur.com/X6JZM.gif). My code is below, i seem to be having a problem getting the range being used for the Text-to-columns delimitation to change. Any ideas?

Please Login or Register  to view this content.

[StephenR]

You don't need to loop, just apply texttocolumns to the whole column D or the used bit of it.

[DFrank231]

You don't need to loop, just apply texttocolumns to the whole column D or the used bit of it.

thanks for the response. the reason i am looping is because the data will not always be that long, so i want the code to be able to reflect the number of line items involved.

i can try modifying it to pasting the TTC all the way down and see if it works out...

[DFrank231]

nevermind! turns out your method works just fine.

thanks, Stephen.