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 :)
|