|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
参与一下。。。
- Sub ykcbf() '//2024.6.16
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- p = ThisWorkbook.Path
- f1 = p & "\1.xlsx"
- f2 = p & "\2.xlsx"
- ReDim brr(1 To 10000, 1 To 2)
- Set wb = Workbooks.Open(f1, 0)
- With wb.Sheets("Sheet1")
- arr = .UsedRange
- wb.Close False
- End With
- For i = 2 To UBound(arr)
- If InStr(arr(i, 1), "QQ") = 0 Then
- m = m + 1
- brr(m, 1) = arr(i, 1)
- brr(m, 2) = arr(i, 2)
- End If
- Next
- Set wb = Workbooks.Open(f2, 0)
- With wb.Sheets("Sheet1")
- .[g2:h1000] = ""
- .[g2].Resize(m, 2) = brr
- wb.Close 1
- End With
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
|