| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing a closed workbook
the INDIRECT formula will not pull values from a closed workbook, wha
is a solution to this? I am trying to reference a cell in a closed workbook on a sheet tha has the same name as the active sheet, so I want to be able to us MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) in the referenc to the other workbook... thank -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing closed file | Excel Worksheet Functions | |||
| Indirect referencing closed spreadsheets | Excel Discussion (Misc queries) | |||
| Referencing cells in closed workbooks | Excel Discussion (Misc queries) | |||
| INDIRECT and Named Ranges referencing closed workbook | Excel Worksheet Functions | |||
| Referencing a closed file | Excel Worksheet Functions | |||
Threaded Mode
