Saturday, 1 September 2012

Excel VBA Macro To Insert Desired No.of Columns

Macro To Insert Desired No.of Columns
Sub Inscols()
Dim i As Integer
Dim j As Integer

ActiveCell.Select

i = InputBox("Enter The Desired No.of Columns To Insert ")

For j = 1 To i
Selection.EntireColumn.Insert
Next j

End Sub

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts