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!