Quote Originally Posted by Alias1431 View Post
Some stock codes have an A or AA at the end, and I would like to include those possible variations in the search. Thanks for your help, guys!
DOH! As it turns out, the cells.find method as posted will look for any instance of the search term in the range. So, for example, if your current search term is "CODE01", and the List of stock codes includes "CODE01A" only, then it would be found. This works to your advantage in certain situations, but I can also be a detriment, like if you only want to find exact matches. I would recommend looking for exact matches, but that's just me.

Greg