View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gene Gene is offline
external usenet poster
 
Posts: 100
Default #REF error in named formula

I have several worksheets in a workbook. I have ABX and XLNX as the first
and last worksheets. I have incorporated ABX:XLNX!J14 to reference cells in
each worksheet in a named formula. I get a #REF error. I put =ABX:XLNX!J14 in
a cell by itself and get the same error. I can't find anything wrong with
the reference
--
GeneS