|
Sub 删除()
t = Timer
Dim r As Long
Dim i As Long
r = Sheet1.UsedRange.Rows.Count
For i = r To 1 Step -1
If Cells(i, 1).Find("*", , xlValues, , , 2) Like "*长时间*" Then
Rows(i).Delete
End If
Next
MsgBox Timer - t
End Sub
这段代码,对A列的含有长时间的行进行删除,运行时间太长,请大家帮忙,如何提速!谢谢!!
- Sub DelBlankRow()
- On Error Resume Next
- t = Timer
- Dim i As Long
- Dim arr
- arr = Sheet1.UsedRange
- For i = 1 To UBound(arr)
- If arr(i, 1) Like "*长时间*" Then
- arr(i, 1) = ""
- End If
- Next
- Range("A1").Resize(UBound(arr), 1) = arr
- Sheet1.Columns("A:A").SpecialCells(xlCellTypeBlanks).Select
- Selection.EntireRow.Delete
- MsgBox Timer - t
- End Sub
复制代码
|
评分
-
查看全部评分
|