Hi Bruce,

Am Wed, 6 Apr 2016 11:39:47 -0700 (PDT) schrieb B Roberson:

Apparently I am going to need some more help. I will post back here once I figure out how to upload. It looks like I need to post a link out of dropbox to you can access it?

I loaded this macro into the full file which has some 4,700 rows. The reason I can't tell exactly what is happening is it appears this look goes through all the rows before it copies anything to the sheet2. I stepped through a lot of the iterations of the loop and it passes through those just fine.

I guess what is happening is when the loop ceased to find anymore rows, it threw up an error message when it encountered the following line.

varOut(n, 0) = Split(varData(i, 1), " ")(0)

After that, it doesn't write anything. Am I close on my guess and would it just need something like an onerror statement to get it to pass on down to where it writes what it did? If I can figure that out, maybe I can build on it to add more fields.

yes, upload the workbook to DropBox and post the link here.
This error occurs if there is no other char in the column with the date.
Therefore it is necessary to see the data.
The macro works into the memory and writes the data in Sheet2 when all
data is done. If it would write row after row it would be slow.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional