Thanks Bob. Your answer seems plausible as indeed only the first cell
is correctly evaluated. It would appear at first sight that EVALUATE
has the autosense to treat a formula as Array if the context points to
that. In my example (Code B), the selected range is populated with the
Array formula but all cells bear the evaluation of the first cell.


TIA


--
Myles
------------------------------------------------------------------------
Myles's Profile: http://www.excelforum.com/member.php...o&userid=28746
View this thread: http://www.excelforum.com/showthread...hreadid=489318