Im trying to construct a vba code which will clear content if cells = 0. However this depends on the previous vba code which changes the format of some cells. My code until now is: Sub Macro1() Application.DisplayAlerts = False Dim lastRow As Variant Range(“A4:A65000”).Select Selection.TextToColumns Destination:=Range(“B4”), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _ Semicolon:=False, Comma:=False,Read more