Tom,

Not long to write this message, ill follow this up in the morning.

Thank you for your post, I will try your code tommorow and see if I can
manipulate it.

In answer: No, only want to search within a worksheet called data.
Interim input is the name of the form which holds the texbox which is
the value i am looking for so that when found I can add more info to
that line.

Anyway i have to rush off so i will re-read the posting tommorow AM,
thank you both for your time.

Duncan