arr = Range("A1:A10").Value For i = 1 To UBound(arr) If arr(i, 1) = 0 Then arr(i, 1) = Empty Next Range("A1:A10").Value = arr