|
- Sub 合并()
Dim arr(), ii&, x&, sh As Worksheet - For Each sh In Worksheets
- If sh.Name <> "年级名次" Then
ii = sh.Range("a65536").End(3).Row
ReDim arr(1 To ii, 1 To 9)
arr = sh.Range("a3:i" & ii)
Worksheets("年级名次").Range("a" & Worksheets("年级名次").Range("a65536").End(3).Row).Offset(1, 0).Resize(ii - 3, 9) = arr
Erase arr - End If
- Next sh
- End Sub
msgbox Worksheets("年级名次").Range("a" & Worksheets("年级名次").Range("a65536").End(3).Row).Offset(1, 0).Resize(ii - 3, 9).address
你看看输出到哪了,
|
|