Sub 跨表复制数据()
On Error Resume Next
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim m As Integer
For m = 3 To Sheets("sheet1").UsedRange.Rows.Count
Sheet1.Range(Cells(m, 1), Cells(m, 8)).Copy
Sheets("源数据").Select
Sheets("源数据").Rows(m + 5).Insert
Sheets("源数据").Range(Cells(m + 5, 1), Cells(m + 5, 8)).Select.Paste
Next m
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub
sheet1改为sheets(1)
追问还是COPY 空的行
追答Sheets("源数据").Cells(m + 5, 1).Paste