Run-time error '13' - Mismatch

[Figboot]

Relatively new to VBA...so I appreciate the assistance.

Aquired a template to parse by column. Everything works fine on the "Original" tab, where column C (or 3 in the code) is parsed. When I change the code in the ParseByColumn macro to Col = 12 in order to parse column L in the "New" tab, it will return a runtime error and say there is an issue with the following line:

Rows(Rw + 1 & ":" & Rw + UBound(MyArr)).Insert xlShiftDown

The macro in the attached sheet is currently set to column 3.

What am I doing incorrect here?

Thanks...

[romperstomper]

Your data at the bottom of column L does not contain any of the delimiters you check for so you never populate the MyArr variant with an array (or indeed with anything), and you can't therefore use Ubound on it. Add an Else condition:

Please Login or Register  to view this content.

and then you should be OK.

[Figboot]

Sorry...excellent with functions but a newbie with VBA. Where in this code should I add the line? I greatly appreciate the help!

Please Login or Register  to view this content.

[romperstomper]

Before the End If line.

Note: I have added code tags to your last post. Please make sure you use them in future whenever you post code, in accordance with forum rules.

[Figboot]

Okay...it now errors on this line:

Please Login or Register  to view this content.

[snb]

if the parsing delimiter is a comma, this may suffice:

Please Login or Register  to view this content.

if the parsing delimiter is a semicolon

Please Login or Register  to view this content.

[romperstomper]

You have some cells that are empty in column L - how do you want those handled?

[Figboot]

Yes, it is a comma. Am I replacing the code that errored, or placing this somewhere else?

Thanks for your patience!

[Figboot]

If a row has column L empty, then it can either be ignored, or just parsed once...really doesn't matter.

[romperstomper]

In that case:

Please Login or Register  to view this content.

[Figboot]

Outstanding! Works great. I greatly appreciate the assistance.