Change Range of an existing Named Range

[jammoca]

Is it possible to change the current range of an existing Named range ?

I'm guessing there are macros that can be written to do this, but I'd prefer to avoid that.

Is there a place I can go that lists the ranges of each of the current named ranges within the worksheet .. and if so, can this list be edited ?

Chris

 

[rhombus4]

Is it possible to change the current range of an existing Named range ?

I'm guessing there are macros that can be written to do this, but I'd prefer to avoid that.

Is there a place I can go that lists the ranges of each of the current named ranges within the worksheet .. and if so, can this list be edited ?

Chris

Insert - Name - Define. Click in refers to to edit the range

 

[mikerickson]

The Name Manager in post 2006 versions will allow you to do that.
Pre 2007, the Insert menu item > Names > Define will get you to that dialog.

These list the Names and their RefersTo. It does not evaluate those RefersTo's.