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