I have a workbook that uses a function called table(,cell).
.. how that feature is used and how the table was set up.

{=TABLE(,Cell ref)}

Its a "one variable data table" which is used for sensitivity analysis.
Albeit it looks like an array formula, it's not. The table needs to be set up
via the menu command: Data Table ..

You could try typing in Excel's help: one variable data table
for more information

Try also the 2* samples on data table in my archives:
*one variable, 2 variable

One variable data table example.xls
http://savefile.com/files/1007074

2 variable data table example.xls
http://savefile.com/files/46276

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Katie" wrote:
No. There is information about the table feature. It is something that is
part of Excel, but does not work like regular functions.

I did find some sites, but don't understand enough to figure out how the
worksheet was put together originally.

here is a site I found that describes the table feature and function, if
that helps anyone understand what I want to find out.

http://support.microsoft.com/default...b;en-us;282851


Katie



"Alan" wrote:

That sounds like a UDF or User Defined Function, ie something that someone
has written, not a built in Excel function.
Try hitting Alt and F11 together to open the VB editor and look in Sheet1,
Sheet2, This Workbook etc on the left.
Look for something that starts 'Function Table () or similar.
Copy and paste the code here and maybe someone will be able to help you with
it,
Regards,
Alan.
"Katie" wrote in message
...

Is there a way to reverse engineer the existing workbook? Unlike other
functions, the predecessors are not neatly indicated in the arguement
list.

Please help!