part of "Mark Twenhafel" <[EMAIL PROTECTED]> original message said:
Here's my question:
I kept thinking that "named ranges" would be a good mechanism to use, as
I remembered "named ranges" of cells from Excel. In OOo, however, named
ranges seem only to be used in association with forms (controls) that are
bound to a database. I never saw a way of naming a range of cells and
then being able to refer to the range by name; something defining
"Dec_Consmpn_Txns = C3:C88". Does this exist in OOo? If not, is there a
rationale for excluding it?
Mark, you can use named ranges in formulas, where the formula refers to one
or more named ranges. For example, if you define the range
"Dec_Consmpn_Txns" as C3:C88 by highlighting that range of cells and then
using the menus INSERT > NAMES > DEFINE and type in the "Dec_Consmpn_Txns"
in the Name field, you can extract the total of the cells in that range with
a formula, located anywhere else in your sheet: =SUM(Dec_Consmpn_Txns).
(The above menu commands are from OOo 1.1.4. I assume, but do not know for
sure, that 2.0 is the same).
John V
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
