|
- Option Base 1
- Sub jsgslgd()
- Dim sh As Worksheet
- Dim i As Integer, j As Integer, k As Integer
- Dim arr(), arrtemp()
- k = 0
- For Each sh In Worksheets
- If sh.Name <> "汇总表" Then
- k = k + 1
- If k = 1 Then
- ReDim Preserve arr(1 To 1, 1 To 20)
- arrtemp = sh.Range("a16:a35").Value
- For i = 1 To 20
- arr(1, i) = arrtemp(i, 1)
- Next
- Else
- j = UBound(arr, 2)
- ReDim Preserve arr(1 To 1, 1 To j + 20)
- arrtemp = sh.Range("a16:a35").Value
- For i = 1 To UBound(arrtemp)
- arr(1, j + i) = arrtemp(i, 1)
- Next
- End If
- End If
- Next
- Sheets("汇总表").Range("a:a").ClearContents
- Sheets("汇总表").Range("a1").Resize(UBound(arr, 2)) = Application.Transpose(arr)
- End Sub
复制代码 这个是用数组做的,试试看。
SG-104 - 产品质量证明书.rar
(576 KB, 下载次数: 9)
|
|