Select the cells (column or just a set of them) and run:

Sub clearum()
For Each r In Selection
If r.Value = 0 Then
r.Clear
End If
Next
End Sub
--
Gary''s Student
gsnu200709


"Luc" wrote:

How do i reset cells wich contain 0 (zero) to an empty cell.:

1.For an entire column
2. For a certain range, example I2 to I25

Thanxxx,

Luc