Published On Jul 8, 2022
EXCEL - Data deletion using VB Code (Very Easy!)
Code:
Sub DelValues()
Dim rng As Range, r As Range, lm As Double
Set rng = Range("A5:A14")
lm = 100
For Each r In rng
If r.Value "condition symbol" lm Then r.Clear // see video
Next r
End Sub
show more