Question

I need a loop/if statement to run in excel that does the following:

Checks the cell to see if the cell has a single zero in it - if it does the zero needs deleted - if not it will go down the column into another cell and check the next one and so on - if you are familiar with processrobot that is the software I am using.

Answer 1

I will be suggesting a VBA script to run that would help you delete the cells which have single 0 in it. To do it,

press alt+f11. Press insert - then press module. It will open the editor window. Then you can paste this code:

func_del DeleteRows()
Dim rng As Range
Dim InputRange As Range
Dim DeleteRange As Range
Dim DeleteStr As String
Set InputRange = Application.Selection
Set InputRange = Application.InputBox("Range :", InputRange.Address, Type:=8)
DeleteStr = Application.InputBox("Delete Text", Type:=2)
For Each rng In InputRange
    If rng.Value = DeleteStr Then
        If DeleteRange Is Nothing Then
            Set DeleteRange = rng
        Else
            Set DeleteRange = Application.Union(DeleteRange, rng)
        End If
    End If
Next
DeleteRange.EntireRow.Delete
End func_del

Note: It will pop up two dialog boxes, in the first one you need to enter the range of the values where you want this function to run. In the second one you need to enter the value that you want to be replaced.