Hi
why not use application.vlookup?

--
Regards
Frank Kabel
Frankfurt, Germany

Jeff wrote:
Hello,

I need to design a VBA macro that would find "paid" in Column A and
would select in value in column H.
Ex:
Column A Column H
Paid $100.00
I need to select the $100.00
Regards