Friday, 31 August 2012

How to Add Desired Number of Sheets in Excel with VBA

VBA Macro To Add Desired No.Of Sheets in an Excel

Sub ADD()
Dim x, Y
x = InputBox("Enter The No.Of Sheets To Insert :")
For Y = 1 To x
Next Y
End Sub

This is a very user friendly macro that allows you to add any no.of sheets whose number is increased automatically[sheet1,sheet2,sheet3...Sheetn],even you run a macro 'n' no.of times.

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