Modifying the range of a Named Range

Jan 20, 2012 at 5:37 AM

What's the best way to change the address range in a existing NamedRange?  Seems to work if I delete the old NamedRange and create a new one but was hoping there is a way to just change the address range in the existing NamedRange but I'm not seeing how to do it.

Jan 21, 2012 at 11:00 PM

Just added namedRange.RefersTo setter and namedRange.SetRefersTo(...) methods...