| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
right syntax
Yes Bob. (2010)
-- Jacob (MVP - Excel) "Bob Umlas, Excel MVP" wrote: oops - yes, typo. Thanks Jacob -(You new to MVP-dom?) "Jacob Skaria" wrote: Hi "pls123" Bob has meant to post =INDIRECT("'[ABC.xlsm]Sheet1'!"&D14&"100") -- Jacob (MVP - Excel) "Bob Umlas, Excel MVP" wrote: =INDIRECT("][ABC.xlsm]Sheet1'!"&D14&"100") "pls123" wrote: hello all ! can anybody show me the right syntax for this.. ='[ABC.xlsm]Sheet1'! & D14 & 100 ..so it could be for example... the cell L100 or BR100.. it depends to the value in D14 tx for help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vba syntax | Excel Discussion (Misc queries) | |||
| Syntax HELP | Excel Discussion (Misc queries) | |||
| SQL syntax | Excel Worksheet Functions | |||
| If then syntax | Excel Worksheet Functions | |||
| Syntax Help | Excel Worksheet Functions | |||
Hybrid Mode
