Replace:
Cells.Find
with:
Sheet2.Cells.Find
--
Vasant
"Sam Torasco" wrote in message
...
Thanks,
Im on the right track now. but how do i tell it to search the data on
sheet2?
Sam
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!