Edit the range of the range with a name

[Steel_lady]

I created a menu defining a name for the range and now when I want to add one more thing to the menu I don't know how to expand the range. I know about the dynamic ranges but I just want to know how to do it in particular cases when it was not previsted to be modified but for some caprice it happened. The thing is that I don't want to create the new meny over it because I already spent the name for the range I want to put.

[arthurbr]

Hi,
I don't really understand what you are trying to do
Why not use dynamic ranges?
You can always use an entire column or row as range, but that wouldn't speed up calculations I think

[davesexcel]

I created a menu defining a name for the range and now when I want to add one more thing to the menu I don't know how to expand the range. I know about the dynamic ranges but I just want to know how to do it in particular cases when it was not previsted to be modified but for some caprice it happened. The thing is that I don't want to create the new meny over it because I already spent the name for the range I want to put.

Goto insert,name,define find the named range and edit the range