How to Creat multiple copies of sheet
 

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

How to Creat multiple copies of sheet
 

try this
Sub CopySheetMultiple()
For i = 1 To InputBox("how many sheets")
Sheets("yoursheetname").Copy After:=ActiveSheet
Next i
End Sub


--
Don Guillett
SalesAid Software

"Venkatesh V" wrote in message
...
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