loop works for one but causes error for other data

I have a loop that works for one sheet, and when i have about 40,000 lines it works fine. But then i have some other data, which is about 500,000 lines, & when i split it into 20,000 or however it causes an error in the loop. The loop runs, but then eventually says theres too much data & afterwards it wont save either and the loop wont run.

Please Login or Register  to view this content.

any help and guidence on this data error, is the data corrupted? Do I need to paste the data as special values of some time in order for the loop to continue to run. Sometimes it runs about 15,000 rows and then crashes, then i tried doing 4,000 rows but then crashes at 3,000 rows (the second program).

any help, appreciated,

Hi gill389

In both instances you're looping through over a million rows (column B has NO data in either of your worksheets). At a minimum, I'd suggest finding the last row used in your data with something like this

Please Login or Register  to view this content.

and then set your range with something like this

Please Login or Register  to view this content.

This will limit your loop to only rows that contain data.

I don't know what you're trying to do. To eliminate loops altogether, you might think about filtering the data on "1324I" and then do your thing.

I'd need to know more to advise you on this.