Copy worksheet and change rangename

Jorge Ribeiro

Guest

Posts: n/a

18th Dec 2008

Hello

I've an Excel application in c# .net that has a worksheet name Template.
My Template worksheet has defined a workbook rangename MaxDate that refers to
$A$1

I wan't to copy that Template sheet to anotherworksheet and change MaxDate
range to MaxDate_new in the newly created sheet

How can i accomplish this?!
best regards

Jorge

« Worksheet that automatically hides removes certain column pasted i | Excel 2007 - Perplexing Undo VBA runtime error »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to copy & paste a worksheet but change 1 bit of the formula?	LB	Microsoft Excel Worksheet Functions	1	8th Apr 2010 07:04 PM
change a range colour after copy to another worksheet	Kezza	Microsoft Excel Programming	3	11th May 2006 02:59 PM
Why does excel change my hyperlinks when I copy a worksheet?	=?Utf-8?B?VFdJTiBIWVBF?=	Microsoft Excel New Users	1	29th Aug 2005 09:45 PM
Copy a column in worksheet with a character change	=?Utf-8?B?cGhvdG93aXo=?=	Microsoft Excel Worksheet Functions	1	5th Feb 2005 03:35 PM
how do i copy formula and change worksheet instead of cell	=?Utf-8?B?ZGFsMDUwNg==?=	Microsoft Excel Worksheet Functions	2	21st Jan 2005 08:41 PM