| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
right syntax
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right syntax
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! =INDIRECT("'[ABC.xlsm]Sheet1'!"&D14&"100") |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right syntax
The function you'd want to use is =indirect().
But =indirect() won't work if the sending file is closed. Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ or http://xcell05.free.fr/morefunc/english/index.htm That includes =indirect.ext() that may help you. === If you have trouble getting to the site, then search google for indirect.ext. I found this alternative site: http://download.cnet.com/Morefunc/30...-10423159.html I didn't look to see if it was the most current version. I'd check the original site every so often to see if it's working. 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! -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right syntax
=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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right syntax
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! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right syntax
=INDIRECT("'[ABC.xlsm]Sheet1'!" & D14 & "100") ok it works!! I corrected the ] you wrote instead of the ' very tx bob ! "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! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right syntax
tx all for help !!
paolo "Dave Peterson" wrote: The function you'd want to use is =indirect(). But =indirect() won't work if the sending file is closed. Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ or http://xcell05.free.fr/morefunc/english/index.htm That includes =indirect.ext() that may help you. === If you have trouble getting to the site, then search google for indirect.ext. I found this alternative site: http://download.cnet.com/Morefunc/30...-10423159.html I didn't look to see if it was the most current version. I'd check the original site every so often to see if it's working. 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! -- Dave Peterson . |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right syntax
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! |
|
#9
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 | |||
Linear Mode
