View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
isabelle isabelle is offline
external usenet poster
 
Posts: 587
Default Indirectly us a Named Range

hi,

the named ranges must be in the same workbook that the INDIRECT formula

--
isabelle

Le 2011-04-21 08:31, chg a écrit :

=MIN(INDIRECT(B4)) returns an #REF Error