View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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?