Hello everyone:
I have this code for inserting column E on the active sheet:
Sub Insert_E_Column()
'
' Insert_E_Column Macro
'
' Keyboard Shortcut: Ctrl+Shift+P
'
Columns("E:E").Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
End Sub
Can anyone modify it so that it inserts this column twice (not just once) and that this action is done in the first 16 sheets in the workbook? And also an alternative for the first 14 sheets as well.
Thanks!
I have this code for inserting column E on the active sheet:
Sub Insert_E_Column()
'
' Insert_E_Column Macro
'
' Keyboard Shortcut: Ctrl+Shift+P
'
Columns("E:E").Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
End Sub
Can anyone modify it so that it inserts this column twice (not just once) and that this action is done in the first 16 sheets in the workbook? And also an alternative for the first 14 sheets as well.
Thanks!