Hi,
I am trying to copy blocks of data from separate workbooks (each block 30,000 to 60,000 rows by 9 columns) and append in one summary workbook. The first file is processed correctly with no issues, but on the second file, I receive an error "Run time error '1004': Application-defined or object-defined error"
simplified extract of code follows:
for file1, lastrow (of the data file) = 635,701 and numrows (of filtered data) = 43,032
for file 2, lastrow (of the data file) = 798,851 and numrows (of filtered data)=54,076
The data from file 2 should be pasted starting with row 43,033 but it stops at the line where the KeyArr is written back to the range in new_book.
I thought that using the array would prevent it, but am I hitting the row limit on the pasting process?
The problem is, I could have up to 3 more workbooks to process, each with another ~40,000 rows to append. I only need values; formats are not critical.
Any ideas?
Thanks in advance,
Dave
Bookmarks