我需要在每个工作表中重复下面的简单宏;实际上,代码在同一个工作表中执行宏。2我如何修复代码?
非常感谢
Sub Macro1()
'
' Macro1 Macro
'
Dim ws As Worksheet
For Each ws In Worksheets
With ws
Application.Goto Reference:="R1C1"
Cells.Select
Selection.UnMerge
Columns("D:D").Select
Selection.Delete Shift:=xlToLeft
Columns("E:E").Select
Selection.Delete Shift:=xlToLeft
Application.Goto Reference:="R10C9"
Range("J10").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.EntireColumn.Delete
End With
Next ws
End Sub
1条答案
按热度按时间cclgggtu1#
如果这是你真正想做的,你只需要一点接触: