|
Sub 第二题()
ar = Sheets("1月").UsedRange
x = Sheets("2月").Cells.SpecialCells(xlCellTypeLastCell).Row
y = Sheets("2月").Cells.SpecialCells(xlCellTypeLastCell).Column
br = Sheets("2月").Range(Cells(2, 1), Cells(x, y))
Sheets.Add
[a1].Resize(UBound(ar), UBound(ar, 2)) = ar
[a1].Offset(Cells.SpecialCells(xlCellTypeLastCell).Row).Resize(UBound(br), UBound(br, 2)) = br
End Sub |
|