Copy worksheet and change rangename

J

Jorge Ribeiro

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedded Excel into Word with Tables 0
Duplicating worksheet based on range and changing worksheet name 3
loop to copy paste 3
Changes in How Code Acts After Upgrade of Excel 2
Excel Template Question... 2
copying a template sheet and inputting a formula into another sheetthat references the new sheet 1
Need Help with Macro Security 1
Calling worksheet-level names using insert Autotext in Word 3

Top