Replacing only Zero "0" from column without changing other number which contains 0

[uday]

Hi

I want a VBA code that will replace only 0 from target column. My problem is whenever I am trying to replace the zero from entire column it is also replacing the other number which contains zero. My target is only replacing zero from column. If the zero is marge with other number it should remain same.

Please find the attachment.

 

[Marc L]

Hi !

No issue is you specify the whole cell to replace …
​

 

[Chihiro]

Something like this? If you are not replacing on the spot, you will need to modify code a bit.

Sub nullZero()
Dim lLast As Long
Dim ws As Worksheet

Set ws = Worksheets("Sheet1")

lLast = ws.Range("A" & Rows.Count).End(xlUp).Row

For i = 2 To lLast
    If ws.Range("A" & i).Value = 0 Then
    ws.Range("A" & i).Replace 0, ""
    End If
Next i

End Sub