| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a copy - Worksheet
Dear All,
I want to create more than 25 copy of the worksheet along with same data. Most of the time i used (Right click) the sheet--Move or copy--create copy. do the same 25 times. Is there any possible to cretae that much sheets in a single program..? Thanks in advance for your reply. Have a Nice day..! Regards, Vadhimoo. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create a copy - Worksheet
You could try this way:-
Sub copysheets() For copies = 1 To 25 Sheets("Sheet1").Copy After:=Sheets(1) Next End Sub Alter the sheet name to suit Mike "Vadhimoo" wrote: Dear All, I want to create more than 25 copy of the worksheet along with same data. Most of the time i used (Right click) the sheet--Move or copy--create copy. do the same 25 times. Is there any possible to cretae that much sheets in a single program..? Thanks in advance for your reply. Have a Nice day..! Regards, Vadhimoo. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create a copy - Worksheet
Hi Vadhimoo,
Here's one way: Sub test() Dim i As Integer For i = 1 To 25 Sheets("Sheet1").Copy after:=Sheets(Sheets.Count) Next End Sub -- Hope that helps. Vergel Adriano "Vadhimoo" wrote: Dear All, I want to create more than 25 copy of the worksheet along with same data. Most of the time i used (Right click) the sheet--Move or copy--create copy. do the same 25 times. Is there any possible to cretae that much sheets in a single program..? Thanks in advance for your reply. Have a Nice day..! Regards, Vadhimoo. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create a copy - Worksheet
Dear Mike,Vergel
Thanks for your help, its working well. "Mike H" wrote: You could try this way:- Sub copysheets() For copies = 1 To 25 Sheets("Sheet1").Copy After:=Sheets(1) Next End Sub Alter the sheet name to suit Mike "Vadhimoo" wrote: Dear All, I want to create more than 25 copy of the worksheet along with same data. Most of the time i used (Right click) the sheet--Move or copy--create copy. do the same 25 times. Is there any possible to cretae that much sheets in a single program..? Thanks in advance for your reply. Have a Nice day..! Regards, Vadhimoo. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy a cell from another worksheet and create a line wrap | Excel Discussion (Misc queries) | |||
| Dynamicaly create/copy a new row in another worksheet | Excel Worksheet Functions | |||
| create a macro to copy a worksheet into another | Excel Discussion (Misc queries) | |||
| Why does excel create a copy of the worksheet i open | Excel Discussion (Misc queries) | |||
| Create Copy of Current Worksheet | Excel Programming | |||
Linear Mode
