It's an array formula, as indicated by the squiggly brackets { }
Array formulas are entered by pressing CTRL+SHIFT+ENTER at the same time, as
opposed to the conventional way of just hitting ENTER.
Array formulas essentially perform multiple calculations across a range.
I think the TABLE function is used for data tables. See this for more info
about data tables:
http://www.ozgrid.com/Excel/data-tables.htm
Dave
--
Brevity is the soul of wit.
"Guylaine" wrote:
I found the formula {=TABLE(G13;)} in a worksheet, and I would like to know
its function. I've checked in Visual Basic and did not find any macro under
that name...