Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multi sheet lookup with multiple results | Excel Discussion (Misc queries) | |||
Build a single order sheet from a multiple page material list. | Excel Discussion (Misc queries) | |||
Multiple sheets as data for a single sheet | Excel Worksheet Functions | |||
multiple sheets vs. 1 sheet | Excel Worksheet Functions | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) |