Revisiting Redistribute a Delimited Column Of Data into Separate Rows

[leukram]

Thanks for looking at this. I pasted the code you posted into a module. When I run the macro, I get Runtime Error '13': Type mismatch. Any ideas on what is causing that? Thanks again for your time.