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.
|