I have tried to write a code to clear zeroes hat contain a formula
It would be appreciated if someone could assist me in resolving this
Code:
Sub ClearZero()
With Sheets("Mar-2020")
If Range("S12:W160").Value = 0 Then
Range("S12:W160").Value = ""
End If
End With
End Sub
Vat.2019.2020.xls | |||||||
---|---|---|---|---|---|---|---|
S | T | U | V | W | |||
17 | 0.00 | 0 | 0.00 | 0.00 | 0.00 | ||
18 | 0.00 | 0 | Journal Check | 574.57 | 574.57 | ||
19 | 0.00 | 0 | 0.00 | 0.00 | 0.00 | ||
Mar-2020 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
S17:W19 | S17 | =D91 |
It would be appreciated if someone could assist me in resolving this