Copy worksheet to another workbook

's Computer Specifications

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

's Computer Specifications

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.

"Jorge Ribeiro" wrote:

> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy cell value from one worksheet to matching worksheet in another workbook	rech	Microsoft Excel Programming	4	29th Sep 2011 03:02 PM
Copy Excel Worksheet to new Workbook via VBA without Links to original Workbook	JamesDMB	Microsoft Access Form Coding	0	21st Mar 2007 06:13 PM
Copy Data from Workbook into specific Worksheet in other Workbook?	kingdt	Microsoft Excel Misc	1	16th Mar 2006 06:55 PM
How do I copy a worksheet form a workbook in my workbook	Neil Atkinson	Microsoft Excel Programming	1	12th Oct 2005 12:23 PM
copy worksheet from closed workbook to active workbook using vba	=?Utf-8?B?bWFuZ28=?=	Microsoft Excel Worksheet Functions	6	9th Dec 2004 07:55 AM