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

RBS

"Durzan" <Durzan.2cgyn0_1155456904.1644@excelforum-nospam.com> wrote in
message news:Durzan.2cgyn0_1155456904.1644@excelforum-nospam.com...
>
> 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
>