VBA Insert Multiple Columns

SUBMITTED BY: gamefreak

DATE: June 25, 2019, 5:34 p.m.

FORMAT: Text only

SIZE: 325 Bytes

Raw Download

HITS: 6711

Report

Sub InsertMultipleColumns()

Dim i As Integer

Dim j As Integer

ActiveCell.EntireColumn.Select

On Error GoTo Last

i = InputBox("Enter number of columns to insert", "Insert Columns")

For j = 1 To i

Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromRightorAbove

Next j

Last:Exit Sub

End Sub