I have a macro written that combines all lines below the header row into a new "Master" tab. It has worked on previous files until now. The total rows of data I am moving into my Master tab is 39,547 lines. While running my macro, I receive an error message stating Overflow. It is giving an error message on this step highlighted below. Why is it now giving an error on this file but hasn't on past files? The # of lines is still below the 65536 rows listed in part of the code and the file size is actually 1048576 (as have the other files that I have ran this macro on and they haven't given any error messages).