I have a User-Defined VBA function that needs to repeateadly find the Row index position of a specific value in a ListColumn.

I've tried using the Range/Find function to return the matching cell index row within the DataBodyRange of the ListColumn, and also created a Custom Collection, which I filled with the ListColumn cell values as Keys, adding each item in same order as the ListRow indexes.

Right now, the workbook only has limited rows, and either method seems to perform quickly, but I'm wondering if anyone knows if there's a speed penalty for using Range/Find vs. just referencing a Collection item by its key for massively-repeated calls and over several thousands of rows.

Is there yet a faster way to do this?

Thank You!