also maybe you can modify it so instead of looking in Sheet2 only, yo
may look in allaof them, but not sure if that's what you want

I do want it to search 2 sheets at once if this is possible. I am onl
a novice at vb though so I'm not sure how to go about this

--
Message posted from http://www.ExcelForum.com