View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default How can I do this ??

One more little twist to this tale....
Twist it all you want, but always start a new thread for each twist. Btw,
INDIRECT doesn't work with closed source files, which is what you are trying
to do. Once you start talking about filepaths, it infers you're trying to
pull something from closed source files. INDIRECT will work only with
simultaneously open source-to-destination files.