"Aladin Akyurek" wrote...
....
Maybe

=ROW() in X99 == {99} instead of 99

because:

=ROW(X99:Z100) == {99,100}

Maybe on your system, but on mine ROW(X99:Z100) returns {99;100}.

Maybe it's required for consistency. ROW() in a multiple cell array formula
does evaluate to a vertical array of the rows. Nevertheless, it'd be nice if
online help mentioned that it always returns arrays.