|
- Sub tt()
- Dim brr(1 To 10000, 1 To 5)
- Range("a2:e65536").Clear
- For Each sh In Worksheets
- If sh.Name <> ActiveSheet.Name Then
- arr = sh.[a1].CurrentRegion
- For i = 2 To UBound(arr)
- n = n + 1
- brr(n, 1) = n
- brr(n, 2) = arr(i, 2): brr(n, 3) = arr(i, 3): brr(n, 4) = arr(i, 4)
- brr(n, 5) = sh.Name
- Next
- End If
- Next
- [a2].Resize(n, 5) = brr
- [a2].Resize(n, 5).Borders.LineStyle = 1
- End Sub
复制代码 |
|