Comma delimited list cell to new row code help

Hello,

I am trying to split any cells with multiple entries, separated by a comma, to new rows. Then I need to copy the information from the original row to the newly created rows. I have a code that will work on a test workbook, but when I run it on the workbook I the code for, it will not separate the data. Here is the code and I will attach the two file also.

Please Login or Register  to view this content.

Thank you for any tips or suggestions. If you have any questions please ask.
John

Hi John

In this code

Please Login or Register  to view this content.

In the file that works, daRow evaluates to 15 and all your coma delimited cells are within that range...so it works. In the file that doesn't work, daRow evaluates to 87 and all the coma delimited cells fall outside that range and aren't getting evaluated.

Welcome to the Forum!

I haven't dug through it in detail, but I notice that the DoesWork workbook has delimited strings in column Q, while Doesn'tWork has numbers (or blanks) in column Q

Hi John
I've some ideas...I'll post back this afternoon.

Hi John

This code has been tested on both books and appears do do as you require. This is the code for CountCommas

Please Login or Register  to view this content.

And this is the code for InsertRows (you'll see that I changed one line of code)

Please Login or Register  to view this content.

Let me know of issues.

You're welcome John...glad I could help.

Please Login or Register  to view this content.

@mikerickson

Of course you're right...since I was rewriting that particular part of the code, I should have rewritten it to make it more efficient. Not sure why I didn't...I knew there were better ways. Still learning myself to lead OP's to better solutions...want them to know "what they have works"...but, try this. It's a balance...working on it.