|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
不知道是不是这个意思。试试看吧。- Sub text()
- Dim wb As Workbook
- Dim i As Integer, rng As Range, d, arr, brr
- Application.DisplayAlerts = False
- Application.ScreenUpdating = False
- Set d = CreateObject("scripting.dictionary")
- Set wb = Workbooks.Open(ThisWorkbook.Path & "\订单汇总表-分拆.xls")
- arr = wb.Sheets(1).Range("a1").CurrentRegion
- brr = Sheet1.Range("a1").CurrentRegion
- If UBound(arr) > 1 Then
- For i = 2 To UBound(arr)
- d(arr(i, 1)) = ""
- Next
- End If
- endrow = Sheet1.[a65536].End(xlUp).Row
- For i = 2 To UBound(brr)
- endrow1 = wb.Sheets(1).Range("a65536").End(xlUp).Row + 1
- If d.exists(brr(i, 1)) = False Then
- If brr(i, 6) <> 0 Then
- Sheet1.Rows(i).Copy wb.Sheets(1).Cells(endrow1, 1)
- End If
- End If
- Next
- wb.Close True
- Set d = Nothing
- Application.ScreenUpdating = True
- Application.DisplayAlerts = True
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|