View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default summary sheet that refers to multiple sheets

Thank you Harlan,

Crystal clear and very informative.

Regards
Martin


"Harlan Grove" wrote in message
...
"MartinW" wrote...
OK thanks Bob, I'm sure Harlan will pipe up if there
is some fundamental issue here. ;-)

...

Since you invited me, ROW always returns an array, ROWS always returns a
scalar. ROW can cause problems when nested in some other functions. ROWS
may be slower, and it may use more memory, but it's generally more robust.
So would you prefer slower correct results or quick errors?