Sub tt()
Dim x%
With Worksheets("表1")
For x = 2 To 6
Worksheets("表" & x).Range("a1365:a2000").Copy .Cells(1365, x)
Worksheets("表" & x).Range ("a1365:a2000")
Next
End With
End Sub
Sub tt()
Dim x%
With Worksheets(1)
For x = 2 To 6
Worksheets(x).Range("a1365:a2000").Copy .Cells(1365, x)
Worksheets(x).Range("a1365:a2000").Clear
Next
End With
End Sub
我改了一下,用这个吧