Automatically search to row in a column
 

I have a spreadsheet set up with a huge list of names, is there a way to
"lock it" and be able to start typing a name, say in the first row and have
it take me right to the correct row with the name? With out using the "edit
--find feature" which i find very time consumming to use every time I need
to get to a different name. Using excel 2002

Thx

Automatically search to row in a column
 

You could use a worksheet_change event to do this. However, you would wait
until all of the name is in.

--
Don Guillett
SalesAid Software

"Mex" wrote in message
...
I have a spreadsheet set up with a huge list of names, is there a way to
"lock it" and be able to start typing a name, say in the first row and
have
it take me right to the correct row with the name? With out using the
"edit
--find feature" which i find very time consumming to use every time I
need
to get to a different name. Using excel 2002

Thx