View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
William Benson William Benson is offline
external usenet poster
 
Posts: 121
Default delete record based on a value

Assuming you mean all values in a single column, then you should put on
Autofilter and set the criterion to =60, then delete results.

If you need to look over every cell in the worksheet for values =60, that's
a different story.
Sub DelValues()
Dim c As Range

For Each c In activeSheet.UsedRange
If c.Value = 60 And IsNumeric(c.Value) Then c.Delete
Next 'c

End Sub



"Anauna" wrote in message
...
Hello,

I would like to be able to delete all values greater than 60 on a
spreadsheet.
--
Thank-you and all suggestions are appreciated.