|
有时正常,有时会提示错误1004,类range的pastespecial方法无效
sub 总D()
Dim i
For i = 13 To 24
Sheets(i).Select
Range("A1").ClearContents
Range("A2:IR1061").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("B1").Select
Next i
End sub
- Sub 总D()
- Dim i
- For i = 13 To 24
- Sheets(i).Select
- Range("A1").ClearContents
- ActiveSheet.Range("A2:IR1061").Select
- Selection.Copy
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
- :=False, Transpose:=False
- ActiveSheet.Range("B1").Select
- Next i
- End Sub
复制代码
|
|