Overflow error

Hi, I'm working on simple code to copy and paste certain rows from a list based on a corresponding list of values. (Specifically, one list contains extraneous rows of data, but I only want to copy/paste the matching rows). My code is:

Please Login or Register  to view this content.

But I'm getting an overflow error with in the Else: j = j + 1 line. Would appreciate if somebody could help me. Thanks!

[Edit: I guess a potential problem is that one of the rows in the first list (i) has no match in the second list (j), which could cause j to increase indefinitely?]

Declare i and j as long instead of integer

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.