Thread: right syntax
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pls123 pls123 is offline
external usenet poster
 
Posts: 121
Default 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!