|
我有一个excel文档,里面有三张表格,名字分别叫: 汇总表 、1、2
我使用下面的代码对表 1和2进行操作的时候汇总表也跟着变化,请问我该如何修改?为什么要这样改,谢谢
Sub 去除公式()
'
' 去除公式 Macro
'
'
Dim i As Integer
Dim y As Integer
y = InputBox("请输入表格数量")
For i = 1 To y
Sheets(i).Select
Columns("A:M").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Columns("A:D").Select
Range("D1").Activate
Selection.Delete Shift:=xlToLeft
Columns("J:K").Select
Selection.Delete Shift:=xlToLeft
Next
End Sub
- Sub 去除公式()
- '
- ' 去除公式 Macro
- '
- '
- Dim i As Integer
-
- Dim y As Integer
-
- y = InputBox("请输入表格数量")
- For i = 1 To y
- If Not Worksheets(i).Name Like "汇总表" Then '判断是否为汇总表,如果不是,则进行汇总
- Sheets(i).Select
-
- Columns("A:M").Select
- Selection.Copy
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
- :=False, Transpose:=False
- Application.CutCopyMode = False
- Columns("A:D").Select
- Range("D1").Activate
- Selection.Delete Shift:=xlToLeft
- Columns("J:K").Select
- Selection.Delete Shift:=xlToLeft
- End If
- Next
- End Sub
复制代码
|
|