|
发表于 2022-1-8 14:42
|
显示全部楼层
本楼为最佳答案
是这样的吗?- Sub 提取透视表数据()
- Dim arr, a As Integer, b As Integer
- Dim wb As Workbook
- Set wb = VBA.GetObject(ThisWorkbook.Path & "\订单登记表(新).xlsm")
- a = wb.Sheets(1).Range("a1").End(xlDown).Row + 1
- b = wb.Sheets(1).Range("a65536").End(xlUp).Row - 1
- arr = wb.Sheets(1).Range("a" & a & ":k" & b & "")
- Sheet1.Range("a2").Resize(UBound(arr, 1), UBound(arr, 2)) = arr
- End Sub
复制代码
|
|