Gord, thanks, I thought about that and have used auto filter many times and
it is very useful, but in this case, 99% of the people accessing this file
will not be able to do that because of lack of Excel knowledge. I want it to
be automatic for them. To find the stock number and the information will be
clear as a bell to them. I'm the person who made the file and I want the
procedure to be easy for them.

"Gord Dibben" wrote:

Have you thought about DataFilterAutofilter?


Gord Dibben MS Excel MVP

On Thu, 6 Dec 2007 20:07:00 -0800, Dino wrote:

I have column 1 consisting of about 3000 stock numbers. Columns 2. 3, and 4
have related information pertaining to those stock numbers in column 1. Using
the "find" feature, I "zero in" on a certain stock number and then have
access to the related info. I want, when the particular stock number is
found, for that entire row to be highlighted so I can retrieve that
information more easily. I am using Excel 2003. Thanks in advance.