I would have to know the error in order to have a thought..
Also, are you sure that the Msgbox line is the bad line?
In any case, I would try Dave's solution first.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"D"
wrote in message

Thank You very much. Place your code into my sheet and I am having one
problem:

It doesn't like the "MsgBox "found in row " & vStatus" portion.

Any thoughts?

(By the way, you are going to make me look like a hero!!!)