|
- Sub tt()
- On Error Resume Next
- Dim wb As Workbook, sh As Worksheet
- Workbooks.Open ThisWorkbook.Path & "\明细表.xlsx"
- Set wb = Workbooks("明细表.xlsx")
- ReDim arr(1 To wb.Worksheets.Count, 1 To 2)
- For Each sh In wb.Worksheets
- n = n + 1
- arr(n, 1) = sh.Name
- arr(n, 2) = sh.[a4]
- Next
- wb.Close False
- [a5].Resize(n, 2) = arr
- [a5].Resize(n, 2).Sort key1:=[b5], order1:=xlDescending
- End Sub
复制代码 |
评分
-
查看全部评分
|