|
参与一下。。。
- Sub ykcbf() '//2024.5.7
- Application.ScreenUpdating = False
- p = ThisWorkbook.Path
- Set sh = ThisWorkbook.Sheets("Sheet1")
- f = p & "\工作表A.xlsx"
- ReDim brr(1 To 10000, 1 To 2)
- Set wb = Workbooks.Open(f, 0)
- With wb.Sheets("Sheet1")
- r = .Cells(Rows.Count, 1).End(3).Row
- arr = .[a1].Resize(r, 3)
- For i = 2 To UBound(arr)
- If Len(arr(i, 2)) Then
- m = m + 1
- brr(m, 1) = arr(i, 2)
- brr(m, 2) = arr(i, 3)
- End If
- Next
- wb.Close False
- End With
- With sh
- .[c3:d10000] = ""
- With .[c3].Resize(m, 2)
- .Value = brr
- .Borders.LineStyle = 1
- .HorizontalAlignment = xlCenter
- .VerticalAlignment = xlCenter
- End With
- End With
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
2
查看全部评分
-
|