| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Workseet Within Same Workbook
Hi All:
How can I copy (exact copy) a worksheet ten more times within the same workbook in one operation? Thanks for your help. Tom |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy Workseet Within Same Workbook
One way:
Public Sub Copy10() Dim i As Long For i = 1 To 10 ActiveSheet.Copy After:=Sheets(Sheets.Count) Next i End Sub If you're not familiar with macros, see http://www.mvps.org/dmcritchie/excel/getstarted.htm In article , lehigh46 wrote: Hi All: How can I copy (exact copy) a worksheet ten more times within the same workbook in one operation? Thanks for your help. Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workseet Colaberation | Excel Worksheet Functions | |||
| how to copy cell contents from one workseet to another worksheet? | Excel Discussion (Misc queries) | |||
| Workseet linking map | Excel Discussion (Misc queries) | |||
| add page number to entire workseet | Excel Worksheet Functions | |||
| Put a Worksheet in a workseet? | Excel Worksheet Functions | |||
Linear Mode
