See this:

http://www.cpearson.com/Excel/ArrayFormulas.aspx

--
Biff
Microsoft Excel MVP


"mark" wrote in message
...
I am attempting to copy a formula and extend the data range and when I do,
the bradkets { } around the new formula vanish and the formula does not
work.
I attempt to put the brackets in manually, and this does not work. What is
this?