How to Creat multiple copies of sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI,
How to Create multiple copies of sheet, at one go.

We have an option "Move or Copy". With this we can copy a sheet only once.

But, how to create multiple copies of sheet (at one-shot)

Thanks & Rgds,
Venkat
 
try this
Sub CopySheetMultiple()
For i = 1 To InputBox("how many sheets")
Sheets("yoursheetname").Copy After:=ActiveSheet
Next i
End Sub
 
Back
Top