mcarter973
Board Regular
- Joined
- Mar 24, 2002
- Messages
- 83
I have the following formula:
=INDIRECT(A5&"'[January 2002.xls]'!AM11")
where A5 = Sheet1 (all tabs in .xls file are sheets (Sheet1, Sheet2,...)
it's returning #REF!
what am doing wrong?
thanks.
=INDIRECT(A5&"'[January 2002.xls]'!AM11")
where A5 = Sheet1 (all tabs in .xls file are sheets (Sheet1, Sheet2,...)
it's returning #REF!
what am doing wrong?
thanks.