Find each occurrence in a column and do for each occurrence

I serious love this forum. Thanks to all for all the help. I think this one is simple, and I already have one method to do it, I'm just wondering if there is a more efficient way to do it. I have a column of numbers and I want to search for a specific value in that column that may happen multiple times. Each time I find that value, I want to do something. If I don't find it, I will do nothing.

I've already written code with a for/next loop that looks at each value and compares it to the value I'm looking for. So, something like this...

Please Login or Register  to view this content.

I guess I just want to know if there is a better way to do that. Thanks for any and all suggestions.

The Find method is more efficient, although frankly I doubt you'd notice the difference unless you've got lots of data. You can find an example in the VBA Help.

Thanks for the reply. Are you talking about this type of routine?

Please Login or Register  to view this content.

If so, this one works with the first instance of the value being found. How do I make it work for multiple instances of the value being found?

Thanks.