ExcelBanter - Copy worksheet and change rangename

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Copy worksheet and change rangename (https://www.excelbanter.com/excel-programming/421492-copy-worksheet-change-rangename.html)

Jorge Ribeiro

Copy worksheet and change rangename

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

All times are GMT +1. The time now is 04:45 PM.