David Farber pretended :
I am using the basic Excel help tool within my 2002 version to investigate
how arrays operate. Specifically, I started with the ROW() function. The
Excel help says that if you put, ROW() into a cell, I used C4, then the row
number should appear and that does work. In the second example it says that
if you put ROW(C4:D6) and then use the Ctrl-Shift-Enter, the rows below the
formula should populate with 4, 5, 6. What happens when I try this is that I
only get a 4 displayed in the cell, C4, where the formula is. The other cells
below are left blank. I tried doing the exact same thing in Open Office Calc
and it worked perfectly. Is there some setting or feature that needs to be
changed or added in Excel? By the way, the array curly brackets do get placed
around the formula after I hit Ctrl-Shift-Enter.

Thanks for your reply.

Formulas *always* must begin with *=* sign

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion