Is there a good way to search an array with VBA? My program looks through an excel file and puts values into an array, but only if the values aren't already in the array. I'm determining if the value is already in the array in pretty much the worst way possible: I loop through every entry in the array and check if it is equal to the value I might put at the end of the array.

So yeah, this is really slow because I have multiple excel files and almost 500000 rows I need to check. Is there something built in to VBA that will help me with this or am I going to dust off my Data Structures and Algorithms textbook and write some search and sort algorithms?

Thanks,

Zack