I have a document that has 2 worksheets. i want to pull
information from one to the other e.g. i want to pull the
first record that has "cdt" as a reference into a
specific cell on the read worksheet. If cdt is not in the
information worksheet then no record will be shown

Thanks

Nick

set rng = somerangeonsheet1.find("cdt")
if not rng is nothing then
rng.entirerow.copy Destination:= _
somespecificrangeinsheet2incolumnA
End if

--
Regards,
Tom Ogilvy

"Nick" wrote in message
...
I have a document that has 2 worksheets. i want to pull
information from one to the other e.g. i want to pull the
first record that has "cdt" as a reference into a
specific cell on the read worksheet. If cdt is not in the
information worksheet then no record will be shown

Thanks

Nick