View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hmm hmm is offline
external usenet poster
 
Posts: 175
Default Name a formula producing an array

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.