I have code that basically compares rows of 5 cells between sheets and then removes duplicates on the master sheet. I get Overflow '6' error, naturally as I have over 50,000 rows. But when I change from Integer to Long and run it, Excel freezes up. I read elsewhere that using For Each instead of using ranges and incrementing is much more efficient. I would appreciate assistance doing that!
Please Login or Register to view this content.
Bookmarks