Dingo0Z wrote:
INDIRECT("C:\Documents and
Settings\DBryant\desktop\B.D.I. SPREADSHEET PROJECT\CONTINUATION
SHEETS\'["&A1&".xlsx]Sheet1'!X1")


I think your first ' is in the wrong place.
Should be after the first "

INDIRECT("'C:\Documents and
Settings\DBryant\desktop\B.D.I. SPREADSHEET PROJECT\CONTINUATION
SHEETS\["&A1&".xlsx]Sheet1'!X1")

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup