| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Indirect to a closed spreadsheet
Hi,
I have a formula =INDIRECT("'S:\STAR\Renewable Energy\Renewable Position Reports\Positions Re-Pointed to ECO\[CCX Position Report - 140408.xls]AGL position - data'!B" & COUNT('S:\STAR\Renewable Energy\Renewable Position Reports\Positions Re-Pointed to ECO\[CCX Position Report - 140408.xls]AGL position - data'!J63:J200) + 62 ) Which finds the latest contract, which are a mix of text and numeric, the count part works fine BUT the indirect part fails Has anyone made a add-in that deals withthis problem, or is there a way around this problem. I have no Control over the remote spread sheet Thanka MarkS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use of the Indirect function on a closed workbook. | Excel Discussion (Misc queries) | |||
| Indirect referencing closed spreadsheets | Excel Discussion (Misc queries) | |||
| INDIRECT should be updated to work on closed workbooks. | Excel Worksheet Functions | |||
| what exactly prevents INDIRECT from accessing closed worksheets? | Excel Worksheet Functions | |||
| Indirect to a closed workbook | Excel Programming | |||
Threaded Mode
