I have a workbook that has two macro buttons. The first, "Import CSV" button manipulates a CSV and imports it onto the first worksheet. The second, "Check CSV" button highlights errors in the CSV.

With some help the "Check CSV code was updated to also check an array of values.

The updated code works if I manually manipulate the CSV and copy it into the worksheet, but it stops after the first row if I import the survey to the worksheet.

I cannot figure out why the code only checks the first row if the file is imported, ant help would be appreciated.

Below are the files I am using.

Good code:
https://dl.dropboxusercontent.com/u/.../GoodCode.xlsm

Broken code:
https://dl.dropboxusercontent.com/u/...rokenCode.xlsm

Test file:
https://dl.dropboxusercontent.com/u/...0/TestFile.csv

Manipulated test file:
https://dl.dropboxusercontent.com/u/...edTestFile.csv