Saturday, 1 September 2012

Excel VBA Macro To Insert Desired No.of Cells

Macro To Insert Desired No.of Cells
Sub Inscells()

Dim i As Integer
Dim j As Integer

ActiveCell.Select

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

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

End Sub

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts