Sub CopyCont() Dim Arr Dim i&, j% Arr = Sheet1.UsedRange.Value If UBound(Arr) > 0 Then ReDim arrtemp(1 To Int(UBound(Arr) / 2) + 1, 1 To UBound(Arr, 2)) For i = 1 To UBound(Arr) Step 2 For j = 1 To UBound(Arr, 2) arrtemp((i + 1) / 2, j) = Arr(i, j) Next j Next i End If Sheet2.ClearArrows Sheet2.Range("a1").Resize(UBound(arrtemp), UBound(arrtemp, 2)) = arrtemp Sheet3.ClearArrows Sheet3.Range("a1").Resize(UBound(arrtemp), UBound(arrtemp, 2)) = arrtemp
Sub test() '(粘贴工作表) Dim Rng As Range Sheet2.Cells.Clear Sheet1.UsedRange.Copy Sheet2.Range("a1")
With Sheet2 Set Rng = .Range("a65536") For i = 2 To .UsedRange.Rows.Count Step 2 Set Rng = Union(Rng, .Range("A" & i)) Next Rng.EntireRow.Delete End With End Sub
Sub CopyCont() Dim Arr Dim i&, j% Arr = Sheet1.UsedRange.Value If UBound(Arr) > 0 Then ReDim arrtemp(1 To Int(UBound(Arr) / 2) + 1, 1 To UBound(Arr, 2)) For i = 1 To UBound(Arr) Step 2 For j = 1 To UBound(Arr, 2) arrtemp((i + 1) / 2, j) = Arr(i, j) Next j Next i End If Sheet2.ClearArrows Sheet2.Range("a1").Resize(UBound(arrtemp), UBound(arrtemp, 2)) = arrtemp Sheet3.ClearArrows Sheet3.Range("a1").Resize(UBound(arrtemp), UBound(arrtemp, 2)) = arrtemp