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!
|