eddvrs
Board Regular
- Joined
- Jul 9, 2007
- Messages
- 88
Hey,
I have a macro that loops thorugh a list of supplier codes on a worksheet and checks each one to see if that number appears in a text file. The text file represents a subset of supplier codes based on location, and as such is frequently updated.
Currently, I'm importing the data from the text file into a dictionary and checking each cell in a column to see if it appears in that dictionary using CO_Dictionary.Exists(activecell.formula)
My code then deletes the whole row if the code in the cell is not found in that dictionary.
This is taking ages as I often have to check about 100,000 rows. Is there a more efficient way for me to do this?
Cheers
I have a macro that loops thorugh a list of supplier codes on a worksheet and checks each one to see if that number appears in a text file. The text file represents a subset of supplier codes based on location, and as such is frequently updated.
Currently, I'm importing the data from the text file into a dictionary and checking each cell in a column to see if it appears in that dictionary using CO_Dictionary.Exists(activecell.formula)
My code then deletes the whole row if the code in the cell is not found in that dictionary.
This is taking ages as I often have to check about 100,000 rows. Is there a more efficient way for me to do this?
Cheers
Last edited:
