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.


"Planner999" wrote in message
...
Mike - This solution does not seem to work because Curr_DU can be
either String (18x) or numeric (18) depending on an earlier setting of
the variable.

JL GWhiz - I am afraid your solution does not work either. It does not
recognise finding specifically the value 18 - it still looks at the
first cell it comes across, which in this case is 18A.

Thanks to you both for your thoughts on this but I am still stuck...

John