View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
algorimancer algorimancer is offline
external usenet poster
 
Posts: 5
Default Returning Arrays, emulating standard function behavior

Uh, sir? ;) Sorry about that, and anyway I was incorrect.

You had asked,

Quote...
Even if I select a range of cells to be filled with the result, all that appears is the first element of the arrray. <<


Just to clarify -- you are array-entering the formula, right? That is,
using Ctrl-Shift-Enter instead of just Enter.
....Quote

And the correct answer is, no, I'd never heard of using
Ctrl-Shift-Enter in Excel. After trying it (it was also suggested by
Stephen Bullen in the ms.p.vsnet.vstools.office group), that seems to
have solved that part of the problem. Thank you :)