Copy Sheet

  • Thread starter Thread starter John Mamani
  • Start date Start date
J

John Mamani

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
 
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")
 
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.
 
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
 
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
 
Back
Top