hi! is there any way to insert any number of worksheets i wish at different times..?! -via135
V via135 Apr 19, 2009 #1 hi! is there any way to insert any number of worksheets i wish at different times..?! -via135
M muddan madhu Apr 19, 2009 #2 try this macro Sub insert_sheet() inrtsh = InputBox("Enter numbers to insert sheets") For i = 1 To inrtsh Sheets.Add ActiveSheet.Name = i Next End Sub
try this macro Sub insert_sheet() inrtsh = InputBox("Enter numbers to insert sheets") For i = 1 To inrtsh Sheets.Add ActiveSheet.Name = i Next End Sub
