|
Sub 宏1()
Dim i%
Range("J2:M10000").ClearContents
For i = 2 To 101
Range("C1,E1,G1,h1").Select
Range("E1").Activate
Selection.Copy
Cells(i, 10).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Next
Range("J1:M1").Select
Application.CutCopyMode = False
Selection.Copy
Cells(Rows.Count, "p").End(xlUp)(2, 1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("h9").Select
End Sub
|
|