Copy and overwriting sheets

[jsolomon]

Hi,
Is there any way to copy a sheet from one book to another and have it overwrite the sheet insead of it renaming it?

Thanks,

Joe

 

[Norie]

Joe

What exactly do you mean?

Do you want to copy the data from 1 workbook to a pre-existing sheet in another workbook?

Workbooks("Book1.xls").Worksheets("Sheet1").Cells.Copy Workbooks("Book2.xls").Worksheets("Sheet2").Range("A1")

 

[jsolomon]

yes, but i need it to bring the cell reference names along with it..

 

[Norie]

Sorry I still don't get what you mean.

Can you explain further?

The code I posted will copy everything.

 

[jsolomon]

I want to copy Sheet 1 from Source workbook to Sheet 1 in Destination workbook. I would like it to overwrite Sheet 1 in the Dest. book. I tried the code you suggested, and everything but the Reference Names are copying over. Any other ideas? Thanks for your help.

Joe

 

[Norie]

Joe

What do you mean by 'Reference Names'?

 

[jsolomon]

like when you go to insert, names, define and assign an array to a name

 

[Norie]

So you mean a named range?

Workbooks("Book1.xls").Worksheets("Sheet1").Copy After:=Workbooks("Book2.xls").Worksheets("Sheet2").

I still don't quite understand what you mean by this.

have it overwrite the sheet insead of it renaming it?

 

[jsolomon]

when i right click the sheet tab, hit copy, and copy it over, becasue the other one has the same name it will just rename it 'Sheet1 (1)'

 

[jsolomon]

that code worked though......thanks for your help!