|
下面的宏是我在工作表的3008行至3012行的实际操作所录制的。老师们一看就知道。1)BF:BK ;2)复制;3)选择性粘贴;4)数据;5)确定。6)B:C ,向下拖动一行;7)保存。共七个步骤。每一行都重复着上面的七个步骤。手工操作很费时而且很会岀错。请哪位老师帮忙写一段宏,可以一次性完成几千行的工作。十分感谢!期待着你的无私帮助。
Sub Macro1()
'
' Macro1 Macro
' 宏由 微软用户 录制,时间: 2013-1-6
'
'
Range("BF3008:BK3008").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("B3008:D3008").Select
Application.CutCopyMode = False
Selection.AutoFill Destination:=Range("B3008:D3009"), Type:=xlFillDefault
Range("B3008:D3009").Select
ActiveWorkbook.Save
Range("BF3009:BK3009").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("B3009:D3009").Select
Application.CutCopyMode = False
Selection.AutoFill Destination:=Range("B3009:D3010"), Type:=xlFillDefault
Range("B3009:D3010").Select
ActiveWorkbook.Save
Range("BF3010:BK3010").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("B3010:D3010").Select
Application.CutCopyMode = False
Selection.AutoFill Destination:=Range("B3010:D3011"), Type:=xlFillDefault
Range("B3010:D3011").Select
ActiveWorkbook.Save
Range("BF3011:BK3011").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("B3011:D3011").Select
Application.CutCopyMode = False
Selection.AutoFill Destination:=Range("B3011:D3012"), Type:=xlFillDefault
Range("B3011:D3012").Select
ActiveWorkbook.Save
Range("BF3012:BK3012").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("B3012:D3012").Select
Application.CutCopyMode = False
Selection.AutoFill Destination:=Range("B3012:D3013"), Type:=xlFillDefault
Range("B3012:D3013").Select
ActiveWorkbook.Save
End Sub
- Sub 数据()
- Dim arr, irow&
- irow = Cells(65536, "BF").End(xlUp).Row
- If irow < 3008 Then Exit Sub
- arr = Range("bf3008:bk" & irow).Value
- Range("bf3008").Resize(UBound(arr), UBound(arr, 2)) = arr
- Range("b3008:d3008").AutoFill Range("b3008:d" & irow), xlFillDefault
- MsgBox "操作完成"
- End Sub
复制代码
|
|