speed up my code?

I need speed!

Can you help speed this up?
(The files might be the problem, each file contains 35,760 lines of numbers,)
I think the problem might be the file size. If anyone knows of a different way to store the file and import it that would be worth a shot.

Please Login or Register  to view this content.

Modifying this section of code to do a bulk write to spreadsheet will speed things up. If one could find the file size before reading it in, the repeated ReDim statements could be avoided.

Please Login or Register  to view this content.

similarly for the second loop

Please Login or Register  to view this content.

Bulk write to spreadsheet is dramaticaly faster than repeatedly writing to one cell. If the files are the same length, it would be worth it to make TempArray two dimesional.