On Mar 9, 4:54 pm, Gary Brown
wrote:
Chip Pearson's website should help you with your question.

http://www.cpearson.com/excel/array.htm


Thanks for the reply. I actually figured out my mistake with the
first one... guess was right, didn't realize formulas count as
values. Changed the test routine and it worked fine.

With regard to the link thanks, I'll take a look. I imagine there's
got to be a way to do the same thing three-dimensionally, I just need
some examples to lead me in the right direction. The routines I write
always seem to fail when they try to test the values in the DIRECT
call... they make the array fine, but collapse with VALUE when they
try to import the values for analysis.

-rt