Run Time Error 1004

[jlax34]

I get the above error when running my "consolidatesheets" Macro. Its the standard can't copy and paste b/c the paste area is not the same size and shape.

The workbook has about 7 tabs of sales information that are identical in format. The macro just takes each tab and copies it into 1 tab so they are in 1 sheet to work with. Originally the macro was written for .xls but I updated all those references to .xlsx to be able to use it for reports that are longer than 65K lines. I made a note on the line that shows up in the debug screen.

Please Login or Register  to view this content.

[6StringJazzer]

I do not see any glaringly wrong. If it were me I would try to debug to see if the values are what I'd expect. I would try something like this immediately before the line that generates the error:

Please Login or Register  to view this content.