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

Hi User, Thank You for visiting My Blog. Please post your open Feedback only related to this Blog Posts. Please note that I cannot respond to the Anonymous Comments.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts