Evaluate uses excel's formula evaluator to return one of
- an error value
- a scalar value
- a row of values
- a column of values
- an array of values
- a range

What it returns depends on what the input was (formula, row/col/rectangular
array of values, range, name etc)
Usually I just assign the result to a variant and work from the the
default property of Range is value anyway so that simplifies things.

Charles
______________________
Decision Models
The Excel Calculation Site.
www.DecisionModels.com


"Arvi Laanemets" wrote in message
...
Hi


"Charles Williams" wrote in message
...
Hi Arvi,

I think ROW() always returns an array because it "returns an array if
entered as a vertical array formula".
And EVALUATE (including the [] syntax) always evaluates formulae as
array
formulae whenever it can.

BTW Name Manager evaluates your NAME as 1 col 1 row containing 2

Thanks for reply!

But is there a better way to get the value, instead of my 2-step approach?

Btw. this ROW's behaves strangely anyway. At start I used it in a complex
formula (=Expr1+Expr2), which also returned the range. I found out, that
the
problem was in ROW(), when divided the complex name into 2 different
names -
after that the one returned a value, the second (HeaderCnt) a range. It
looks a bit strange to me, that a value (number) added to a range is
returning a range!


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)