Hi!

You don't need to use Indirect unless you are using other cells to hold
references to the other workbook.

For example:

You want to return the value of cell A1 on Sheet!125 in workbook file_name.

You might do something like this:

A1 = file_name
B1 = 125

=INDIRECT("'["&A1&".xls]"&B1&"'!A1")

OR

=INDIRECT("'[file_name.xls]"&B1&"'!A1")

If you don't have references to the other wb in other cells, you could just
use this:

='[file_name.xls]125'!$A$1

The above can be used whether the other file is open or not. If it was
closed, you'd have to include the full path in the formula:

='C:\path\[file_name.xls]125'!$A$1

The big disadvantage to Indirect is that it requires the other file be open.

Biff

"Ken Cobler" <Ken wrote in message
...
I am getting messed up on the grammar for this function. I am trying to
refer to a Worksheet called "125" - - which is on a different (opened)
Workbook.

How do I use the INDIRECT function so that it will go to a specific
Workbook, pick the correct '125' tab on that workbook, and return to me a
fixed cell value?

Thanks for your help. Excel Help is not clear about the grammar.

Thanks.