|
楼主 |
发表于 2016-6-18 18:11
|
显示全部楼层
老司机带带我 发表于 2016-6-18 17:21
自己修改运用起来很好,唯一一点就是不直观。谢谢您,我会和下面代码一起组合使用,有问题再向各位大师请教!
- Sub NowModule()
- Dim VBC As VBComponent
- Set VBC = ThisWorkbook.VBProject.VBComponents.Add(vbext_ct_StdModule)
- With VBC.CodeModule
- If .Lines(1, 1) <> "Option Explicit" Then
- .InsertLines 1, "Option Explicit"
- End If
- .InsertLines 2, "Sub 选择性粘贴值()"
- .InsertLines 3, "Sheets.Select"
- .InsertLines 4, " Cells.Copy"
- .InsertLines 5, " Cells.PasteSpecial Paste:=xlPasteValues"
- .InsertLines 6, " Application.CutCopyMode = False '取消复制后边框虚线闪烁问题"
- .InsertLines 7, " Sheets(""测试 (4)"").Activate"
- .InsertLines 8, " Sheets(""管理 (模板) (2)"").Activate"
- .InsertLines 9, " Range(""A6"").Select"
- .InsertLines 10, "End Sub"
- .AddFromString "Sub Process2()" & Chr(13) & vbTab _
- & "MsgBox ""这是第二个过程!""" & Chr(13) & "End Sub"
- End With
- Set VBC = Nothing
- End Sub
|
|