A name can be
- an array of constants
- a range
- any valid formula or array formula (both could include ranges, functions
and arrays of constants)

entering the name definition using ctrl-shift-enter is not required.

Using Names will NOT usually decrease calculation time and in many cases
will actually increase it.

see my website for a lot of material on how to reduce calculation time

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"hmm" wrote in message
...
I defined a name that was equated to an array of values returned by a
function. After typing the definition, I tried pressing ctrl-shift-enter.
The function works properly, but I don't see the definition in braces {}
when selecting the name (in the Define Name dialog box).

Can a name be entered as an array? Reducing calculation time is the name
of
the game here.