Thread: right syntax
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default 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")
Reply With QuoteReply With Quote