Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT.EXT with vector reference
INDIRECT.EXT, from Laurent Longre's Morefunc 4.2 Add-in, is giving me a
"#VALUE!" error message in the cell with the formula: =SUM(INDIRECT.EXT("[MyBook.xls]MySheet!$A$1:$A$3")) when MyBook.xls is closed; it only works when I open MyBook.xls. From what I've seen in the help file and other posts in this forum, it is supposed to work for closed workbooks and for ranges of cells. How can I get it to work? Perhaps there is an update, or a way of using this function that I'm not aware of? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDIRECT.EXT reference | Excel Discussion (Misc queries) | |||
INDIRECT.EXT Help Required | Excel Worksheet Functions | |||
Error using Excel add-in with INDIRECT.EXT function | Excel Discussion (Misc queries) | |||
INDIRECT.EXT help needed | Excel Worksheet Functions | |||
INDIRECT.EXT question | Excel Worksheet Functions |