Most efficient way to search a range
 

Hey Ken if you post your existing code it would be more helpfull for others
to improve it for you

Dan Thompson

"Ken Warthen" wrote:

I have a named range with eight columns and 3700 plus rows. I need a fast
and efficient manner of searching for all incidents of a given name in column
E and return the values of column B for each row where a column E value
matched the search name. I've kludged some code that works, but it's takes
way too long to return results. Any help or direction would be greatly
appreciated.

Ken Warthen