Thank you Gary,

What I found that I had to do to the script you provided was to add "
around the 0 and then it worked like a charm. You will never no how
much time this little Macro is going to save myself and three others
that work with me.

If Cells(i, 2) = 0 Then


If Cells(i, 2) = "0" Then

Thanks a million,


Ron


--
Duster142
------------------------------------------------------------------------
Duster142's Profile: http://www.excelforum.com/member.php...o&userid=27738
View this thread: http://www.excelforum.com/showthread...hreadid=472470