Overflow error, can't see why

Hello!

I'm writing a Macro that is working with two different sheets with the same data for different times, it's gonna take one column from the last one and compare it to a column from the other sheet. The Sheet contains about 2900 rows, and each word/value that it checks must be found in the other one (because they can be changed dissapear betwen timeperiods).
When I've, for a test, made the two sheets with less values (like 20 instead) it works. The error points at the first loop.

Anyway here's the code:

Please Login or Register  to view this content.

Hi,

I'm not really sure, but maybe the offset property is causing the error? Does it work with using Cells in the first loop?

Please Login or Register  to view this content.

Hello!

It's the third line in the first loop:

Please Login or Register  to view this content.

Altough I get the overflow from the two previous lines sometimes as well, gonna try to change the offset function

Hello! Thanks for your answer, unfortunatly I still get an overflow message in line:

Please Login or Register  to view this content.

Got to say there is quite a number of data, about 2900 rows in each sheet

Originally Posted by RHCPgergo

Hi,

I'm not really sure, but maybe the offset property is causing the error? Does it work with using Cells in the first loop?

Please Login or Register  to view this content.

I know changed the variable klick to a Long and didn't get overflow, so it seems to be working, thanks alot!

Originally Posted by Alexander_V

Hello! Thanks for your answer, unfortunatly I still get an overflow message in line:

Please Login or Register  to view this content.

Got to say there is quite a number of data, about 2900 rows in each sheet

Norie:
Ye just thought of that too, maybe always having a long as declaration of big numbers. Thank you