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

Gene,

as pointed out in your post =ABX:XLNX!J14 would be a reference to sheet
ABX:XLNX cell J14 except that it would ne an liiegal sheet name because of
the colon.

Maybe you want to sum J14 in every sheet, in which case the correct syntax is
=SUM(ABX:XLNX!J14)

where ABX is the first sheet and XLNX is the last.

Mike

"Gene" wrote:

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

Check your other posts, too.

Gene wrote:

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

--

Dave Peterson