Runtime error 6 "overflow" help

[lilsnoop]

Good day,

I am really hoping someone can advise how I can resolve a runtime error 6 "Overflow", that I'm getting at the bolded area in my code. I didn't get this error with a smaller data set, but with larger data sets I get this error and I really need to access larger data loads: Thanks in advance for any suggestions!

Please Login or Register  to view this content.

[davesexcel]

I have tested the code and do not get an overflow error using 900k rows. Could it be possible the destination workbook is an .xls file and does not have enough rows?

Could you explain what kind of data is on the workbook.

[lilsnoop]

Hello Davesexcel!

The macro should pull data from a closed workbook with an .xlsx extension into my master workbook which has a file extension of .xlsb

Very puzzling! Appreciate your help!

[davesexcel]

Is it a huge amount of data, I just used random numbers when I tested it.

[lilsnoop]

davesexcel-I tried a sample set of data too with 17000 rows and it worked. So I'm truly puzzled why it works with less data, but gives me the error for the whole report, which is only 17,000 rows. Thanks for your time.