tim_o_mast wrote...
I need to use an Indirect to another wookboot that has a multi-word
name ie
'expense report' not something like 'er' in my excel I did the
following to
test
a1 = [expense report]
b1 = sheet1
c1 = a2
d1 = indirect(a1&b1&"!"&c1)

if I use a name in a1 with no spaces ie 'er' then the indirect works
but if
I use the above example I always get #ref error in cell. Anyone got
any
ideas?

I also did try d1 = indirect("'"&a1&b1&"'!"&c1). It didn't work
either.

If the other workbook is named "expense report.xls" (without the double
quotes, which I included only to delimit the filename including the
space char), and if that workbook is open in the *same* Excel session
as the workbook containing the formula, then you'd get a #REF! error
because your A1 cell didn't include the ".xls" at the end of the
filename. Try changing A1 to

[expense report.xls]

If you still get #REF! errors, then in a blank cell type = and then
press the [Ctrl]+[F6] key combination repeatedly until Excel activates
the expense report workbook, then move the active cell to Sheet1!A2 in
that workbook and press [Enter]. What's the resulting formula in the
original workbook?

If you mean that the workbook's filename on disk includes the square
brackets, then your problem is partially self-inflicted. The exercise
in the preceding paragraph is meant to determine whether this is the
case.