Not really "a slopy (slopPy) way of programing!"
To get more than a couple of dates this is a GOOD way.
You can also use FIND next. See the example in vbe HELP.
To find just one then best to just use FIND

--
Don Guillett
SalesAid Software

"Robert Couchman" wrote in message
...
Hi,

thank you for your advice but this is a slopy way of
programing! what i would like is a strict piece of program
that will search the correct field and if it returns the
correct value, then it will select the entire row and copy
all the contents into sheet 2.

if this is not possible or nobody has a tidyer way of
doing this please can someone consider only copying
specific data as this is only to be used as a mail merge.

i have considered using the offset command and the if not
function.

any suggestions please,

Thank you,

Robert Couchman