For Each cell In Range("E3:AE77")
If cell.Value 0 Then cell.Value = 0
Next cell

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Terri" wrote in message
...
Hello,
I have Cells E3:AE77 selected. How can I assess each cell in the range
selected and if the cell value is 0 then change the cell value to 0.
Also,
how do I have the macro stop after all the cells in the range have been
assessed.

Thank you all for your help!

Terri