On 25 Mar, 01:12, "JLGWhiz" wrote:
I don't know what to tell you. *I tried it several different ways to get it
to pick another value with 18 in it and it went straight to the solo 18
every time using the LookAt:=xlWhole.


Hi JLGWhiz

Solved it and it worked. - I copied your code into the macro but the :
was missing after the LookAt statement.

Intrestingly VB allowed the statement to run without errors.

Anyway thanks

John