Replace the bit in your recorded macro:
Cells
with:
Columns(1)

RBS

"Durzan" wrote in
message ...

How do I make the formula search the data I put in E1 and limit it's
search to column A?


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