Overflow error when concatenating

[Newbie_Nick]

I'm using a simple VBA algorithm to eliminate duplicate elements of a huge table containing about 30 000 rows.

I merge 4 cells containing parts, vendors, prices and currency into one single cell, using a while loop, and compare those single cells and remove duplicates.

However when the table exceeds 32000+ rows I get a Runtime error 6 - overflow while concatenating the cells at row 32 627 or something like that. What might be the issue? Is there a way to avoid this?

Thanks
Nick

[Mallycat]

Just a guess, but have you tried writing the results into a temp cell first prior to doing the comparisons?

[DonkeyOte]

I suspect you've declared an incrementing variable as Integer type, you should use Long.

[Newbie_Nick]

Just a guess, but have you tried writing the results into a temp cell first prior to doing the comparisons?

Yes I did.

I suspect you've declared an incrementing variable as Integer type, you should use Long.

Yup, that was it. Thanks!