|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 ykcbf1100 于 2024-4-15 08:43 编辑
数据量大的话,用数组会快很多。
- Sub 删除不满足BW列条件行()
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- With ActiveSheet
- r = .Cells(Rows.Count, "bw").End(xlUp).Row
- c = .UsedRange.Columns.Count
- arr = .[a1].Resize(r, c)
- ReDim brr(1 To r, 1 To c)
- For i = 2 To UBound(arr)
- If arr(i, 75) = "是" Then
- m = m + 1
- For j = 1 To UBound(arr, 2)
- brr(m, j) = arr(i, j)
- Next
- End If
- Next
- .UsedRange.ClearContents
- .[a1].Resize(m, c) = brr
- End With
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
|