| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I delete a row from a spreadsheet if criteria is not met i.
In a spreadsheet, a column has 30 minutes or 60 minutes. Is there a way to
delete the entire row if the minutes < 30? |
|
#2
|
|||
|
|||
|
Need VBA for that
Dim iLastRow As Long Dim i As Long iLastRow = Cells(Rows.Count, "A").End(xlUp).Row For i = iLastRow To 1 Step -1 If Cells(i, "A").Text = "00:30" Or Cells(i, "A").Text = "01:00" Then Rows(i).Delete End If Next i -- HTH Bob Phillips "wonderboy55" wrote in message ... In a spreadsheet, a column has 30 minutes or 60 minutes. Is there a way to delete the entire row if the minutes < 30? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
| Some exported records do not show on spreadsheet | Excel Worksheet Functions | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I delete blank rows at the bottom of a spreadsheet to get . | Excel Discussion (Misc queries) | |||
| How do I delete 100 account numbers from a spreadsheet colume wer. | Excel Worksheet Functions | |||
Linear Mode
