|
- Sub test()
- Dim n, A, B(1 To 10 ^ 4, 1 To 5), i, j, s, shName
- For n = 1 To Sheets.Count - 1
- A = Sheets(n).Range("A1").CurrentRegion
- shName = Sheets(n).Name
- For i = 2 To UBound(A)
- s = s + 1
- For j = 1 To UBound(A, 2)
- B(s, j) = A(i, j)
- Next j
- B(s, UBound(B, 2)) = shName
- Next i
- Next
- With Sheets(n)
- .Range("a2:e65536").ClearContents
- .Range("a2").Resize(s, 5) = B
- End With
- End Sub
复制代码
实验2.rar
(10.8 KB, 下载次数: 33)
|
|