how to delete existing name ranges in the worksheet and create new one with the same name?
I have situation that I have two worksheets. One worksheet has defined named ranges and I need to define same named ranges on the second sheet and then delele first worksheet.
I am able to delete the named range with Delete(), but when I want to create new named range with Add with the same name as previously deleted named range, it does not work.
Do you have any examples how to work with named ranges?
I am using version 126.96.36.1996.
Thanks in advance.