Text to Rows Macro : Subscript out of range error!

Hi Guys,

I am trying to perform a text to rows for comma delimited column entries. I have included the screenshot of the raw data and the clean data. I am also including my code and a screenshot of it in the excel vba window. If you could please guide me with what I am doing wrong I would really appreciate it.

Please assume column B and C are switched around. I forgot to make that change!

Try

Please Login or Register  to view this content.