Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Copy a sheet more than one time
Hi again!
Is there a way to make more than one copy of a sheet? Lets say that i would like to copy my sheet 12 times, how can i do that? Thanks again. Marko |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Copy a sheet more than one time
Hi marko,
1.copy gives 2 sheets. 2.Select original and copy (click original's tabpress shift while you click copied sheet's tab) 3.copy again gives 4 sheets. 4. Select original and the three copies as before 5.copy again gives 8 sheets etc etc for 16,32, 64.... Ken Johnson |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Copy a sheet more than one time
Marko
Sub SheetCopy22() Dim i As Long Application.ScreenUpdating = False howmany = InputBox("Copy Active Sheet How Many Times?") For i = 1 To howmany ActiveSheet.Copy Befo=Sheets(1) Next i Application.ScreenUpdating = True End Sub Gord Dibben Excel MVP On 10 Dec 2005 14:07:14 -0800, "marko" wrote: Hi again! Is there a way to make more than one copy of a sheet? Lets say that i would like to copy my sheet 12 times, how can i do that? Thanks again. Marko |
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Copy a sheet more than one time
Thanks! Great code! It works brilliant!
Marko |
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Copy a sheet more than one time
Thanks!
Marko |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Sheet frustrations | Excel Worksheet Functions | |||
Move or copy sheet causing the creation of an htm file | Excel Discussion (Misc queries) | |||
time sheet | Excel Discussion (Misc queries) | |||
Time stamp in Excel Sheet | Excel Discussion (Misc queries) | |||
Copy 1 Sheet to Another | Excel Worksheet Functions |