View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Nested String Filename Variable

Works here - did you include ".xls" in the file name? Does your
worksheet name really start with 4 spaces?

In article ,
ed9213 wrote:

Thanks for the suggestion. It didn't work for me, though. The reference
file is open, but using that "INDIRECT" script returns an error in which A1
is blue. I surrounded the filename in A1 in quotes, and that didn't resolve
it either