自己录制修改了一段宏代码,不知道再怎样修改了{:041:}
请各位老师看看,
Sub 粘贴2()
Selection.Copy
For i = 1 To 20
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues
Next
End Sub
Sub 粘贴2()
Dim x, i
x = InputBox("请输入:")
Selection.Copy
For i = 1 To x
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues
Next
End Sub
Sub 粘贴2()
Dim x, i
x = InputBox("请输入:")
Selection.Copy
For i = 1 To x
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues
Next
End Sub