Hi Charley,

Thank you for posting in MSDN managed newsgroup!

From my understanding to this issue, you are going to find one quick way to filter some values from the excel worksheet.

If all the values in the cells are not sorted, you will need to use Loop to pick up the values you want. So far as I know in this scenario, the quickest
way for you is to use SpecialCell method as Jim has suggested. For the usage of SpecialCell mentioned in your reply, I agree with that you should
hide some cells so that SpecialCell can filter the value for you.

Furthermore, if all the values has been sorted, it will be simple for you to obtain the specified value. I'd suggest you can sort the values during the
creation of the worksheet and then it will be very fast for you to locate these special values.

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.