Variable-sized NAMEd range

[hershmab]

I have a column-vector that starts at a fixed row (NOT Row 1) and continues down to the last-used cell in that column. The number of used rows varies from time to time, getting either bigger or smaller according to needs. I have defined a Name for that vector and the name is used in several formulas.

My problem is that the Named area changes automatically but does not follow the principle of referring to all and only the used area. This puts out all the affected formulas and forces me to redefine the name whenever it happens.

If I define the end of the vector by

1. an absolute row address, the Name should never change but does;
2. a relative row address, it should change does does not do so predictably.

It would not matter if the name referred to empty rows as the formulas take care of that.


So the question is: how can I define the name so that it always refers to the currently-used part of the column, or at the very least to the open-ended/half-closed part?

 

[BiocideJ]

Activate Formulas | Name Manager.
Define BigNum as referring to:

=9.99999999999999E+307

Repeat the procdure for BigStr which must refer to:

=REPT("z",255)

I had never considered using named ranges to define a constant value.

 

[Aladin Akyurek]

I had never considered using named ranges to define a constant value.

I don't follow what you are trying to say. This is not "using named ranges to define aconstant value." Rather, it is a name defined to refer a constant value. You could define Pi for example as referring to: =3.14 and use the name Pi all of the appropriate calculations.