right syntax
in [Functions]
|
From: pls123 on 5 May 2010 10:02 =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! > >
From: pls123 on 5 May 2010 11:18 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/3000-2077_4-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 > . >
From: Bob Umlas, Excel MVP on 5 May 2010 15:29 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! > > >
From: Jacob Skaria on 6 May 2010 00:18
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! > > > > |