Searching cell with zero value and delete their content
Am Sun, 10 Feb 2019 10:25:06 -0800 (PST) schrieb Norbert:
I have a range of cells which I'd like to search for the value "0%" (or just 0) and then I'd like to delete all these zero values.
The cell range is M17:AF17
All I want is to delete the zero values in that range.
Dim rngC As Range
For Each rngC In Range("M17:AF17")
If rngC = 0 Then rngC.ClearContents