|
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! |
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") |
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 |
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! |
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! |
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! |
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 . |
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! |
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! |
| All times are GMT +1. The time now is 02:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com