Copy and Pasting Issue (Runtime error '1004')

Hi,

I came across an issue with my code only when the next batch of data to be copied and pasted reached row number 62284, noting that 6000+ rows are attempting to be copied.
Prior to tis row number being reached everything worked fine. Is there a method to fix this by removing the max rows Excel allows?

Please see my code below:

Please Login or Register  to view this content.

I appreciate all the help given.

Regards,
Dave

No, there is no max row, subject to excel limits- which is over 1m in 2007
this line looks in to the next empty row

Please Login or Register  to view this content.

AB33,

Correct the next empty row. Slight typo.
Any help on the copy and pasting issue?

I do not know which one is the active sheet, but assuming it is sheet raw data

Please Login or Register  to view this content.