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
Download
0 formats
No download links available.
EXCEL - Data deletion using VB Code (Very Easy!) - Code in description | NatokHD