| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Sheet
Good Morning all
We are using MS Excel 2002 Using VBA Code, is there a way to copy a single entire sheet from a diferent workseet? Regards, Bre-x |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Sheet
This from VBA help file. Creates a new sheet and copies.
Worksheets("Sheet1").Copy After:=Worksheets("Sheet3") If you want to copy from Sheet 1 to Sheet 2 Worksheets(1).Cells.Copy Worksheets(2).Range("A1") "John Mamani" wrote: Good Morning all We are using MS Excel 2002 Using VBA Code, is there a way to copy a single entire sheet from a diferent workseet? Regards, Bre-x |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Sheet
Hi,
Thank you for you quick answer. This is to copy sheet between the same worksheet right? We need to copy sheets from another worksheet. "JLGWhiz" wrote in message ... This from VBA help file. Creates a new sheet and copies. Worksheets("Sheet1").Copy After:=Worksheets("Sheet3") If you want to copy from Sheet 1 to Sheet 2 Worksheets(1).Cells.Copy Worksheets(2).Range("A1") "John Mamani" wrote: Good Morning all We are using MS Excel 2002 Using VBA Code, is there a way to copy a single entire sheet from a diferent workseet? Regards, Bre-x |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Sheet
The first one copies a worksheet, creates a new worksheet in the same
workbook with the data from to copied worksheet. The second one copies the data in a worksheet to an existing worksheet in the same workbook. For more information, see this website. http://www.rondebruin.nl/folder.htm "John Mamani" wrote: Hi, Thank you for you quick answer. This is to copy sheet between the same worksheet right? We need to copy sheets from another worksheet. "JLGWhiz" wrote in message ... This from VBA help file. Creates a new sheet and copies. Worksheets("Sheet1").Copy After:=Worksheets("Sheet3") If you want to copy from Sheet 1 to Sheet 2 Worksheets(1).Cells.Copy Worksheets(2).Range("A1") "John Mamani" wrote: Good Morning all We are using MS Excel 2002 Using VBA Code, is there a way to copy a single entire sheet from a diferent workseet? Regards, Bre-x |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Sheet
I didnt explain myself well.
Here is what I was looking for: Sheets.Add Type:= _ "F:\1CNC\APPS\EXCEL\template_01.xls" Thank you all for you help We are using MS Excel 2002 Using VBA Code, is there a way to copy a single entire sheet from a diferent workseet? Regards, Bre-x |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
| Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet. | Excel Programming | |||
| Copy hidden sheet and then make copy visible HELP? | Excel Programming | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
| providing a sheet-copy event or copy CustomProperties | Excel Programming | |||
Hybrid Mode
