Deleting values less than 100
Select the cells and run this macro:
Sub clearsmall()
Dim r As Range
For Each r In Selection
If r.Value < 100 Then
r.Clear
End If
Next
End Sub
--
Gary''s Student - gsnu200826
"PointerMan" wrote:
I want to select a large range of cells and delete the cells that have a
value less than 100. Any suggestions?
|