Record a macro that does a find for say 10.
This is under Edit, Find.
Look at the produced code.
Replace this bit:
What:="10"
with this:
What:=Cells(5)

RBS

"Durzan" wrote in
message ...

I was wondering how to create a search function that would search column
A for whatever was put in E1. I am completely new to this sort of thing.
Sorry


--
Durzan
------------------------------------------------------------------------
Durzan's Profile:
http://www.excelforum.com/member.php...o&userid=37447
View this thread: http://www.excelforum.com/showthread...hreadid=571126