选择只是定位光标,下一个动作就是光标。因此,您可以删除select语句,然后移动
ActiveCell.whatever
。唯一的例外是使用正确的工作表,我只是用
with
陈述确保
End When
如下所示。
Sub ExSD_InsertColumns()
' ExSD_InsertColumns Macro
'
With Sheets("ExSDReport")
.Columns("B:C").Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
.Columns("E:E").Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
.Columns("G:H").Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
.Range("B1").FormulaR1C1 = "ARC"
.Range("C1").FormulaR1C1 = "Unit Type"
.Range("E1").FormulaR1C1 = "Work Pool ABBR"
.Range("G1").FormulaR1C1 = "Date"
.Range("H1").FormulaR1C1 = "Time"
End With
End Sub
Good one-stop shop on this topic