Inserting cells to the left based on cell value

Hi All,
well my post from yesterday was answered quickly (THANKS Pike) but I noticed a quirk in my data sets that necessitates some additional coding.
I have multiple test results (as CSV text files) in a directory that I can now import at the push of a button, but I noticed that some of the test results have an additional 16 columns of data in (they have 4 channels tested not just 2). Upshot is that during the test import, I need to see if the value of the field (always column "AP") reads as "Line3-DCVoltage3", ( this unit has the extra lines being tested), if this is true then I need to insert 16 blank cells (to the right of course) before the next cell is imported (would now be "BF")

Or to put it another way, if "AP" = "Line3-DCVoltage3", then skip to column "BF" and continue with the text import, else do nothing .

Code currently reads as follows:

Please Login or Register  to view this content.

Thanks for your help

Sure can, attached are a couple of the csv files, one with 2 test channels and one with 4.
When I run the code, the first part brings in the text just fine.

Please Login or Register  to view this content.

The second part of the code is meant to search through and find the text "MocaTxBitRate" in column AP, and if true, insert 16 blank columns. Unfortunately it seems to insert 16 columns regardless of the conditions. So I know that the insert part works, the only issue seems to be not inserting if the condition is false. There is also probably a better way than just repeating the command 16 times, this seems a bit of a brute force method.

Please Login or Register  to view this content.

Thanks again, you have been a huge help. Excelforum is indeed the only place to go for help.