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...

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...

It's put in by Excel (you can't enter it) when you use the Data/Table
command


"Guylaine" wrote in message
...
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...