Copy worksheet to another workbook

[Jorge Ribeiro]

Hello

I've two worksheets (SheetA and SheetB) in one worklbook Workbook1;
My SheetA has a named range RangeSheetA
I SheetB i have a cell that computes =RangeSheetA * 100

I want to copy both sheets to another workbook, using VSTO .net and keep the
same range relation.
When i copy those sheets to a new workbook i break my range formula... in the
new SheetB the formula points to the range in the other file.

Can you assist me here

Regards

Jorge

 

[Joel]

I would save the present workbook to a new name using SAVEAS. You can then
delete the sheets in the new book that you don't need.