Hi Bob,

What's the weather like over there?

Funny you should ask. I am in an island, took time away in order to
write on - guess what - Excel for my future courses. I have limited
access to the internet, which makes every visit to the NG minimalistic
and rather frantic. The weather is disappointing for the more southern
lattitude but this has been a long winter anyway.

Anyway, I had suspected something along these lines, judging from the
behavior of the Evaluate Formula tool, which evaluated the last call to
ROW() as a single element array. Funny thing is Excel crashed when I
attempted to evaluate INDIRECT, which made me think I reached a bug in
the function.

The reason I had used N() was rather different, it was to commit the
range reference into becoming numbers - such was my understanding
following discussions on OFFSET and INDIRECT in other threads. I still
do not fully understand why &ROW() produced and array in this context,
it was outside the MAX() function, I thought it entirely a scalar
context.

Anyway, the formula is working *thank you*, now my task is to further
experiment and maybe understand what is happening with these elusive
functions. I will write back when I have a more concise question and
access to the internet again.

Until then,

Kostis