=Sales_Prod1_06
Think you must array-enter the above multi-cell defined range (ie press
CTRL+SHIFT+ENTER - CSE) into a horiz range of the same size -- select 12
horiz cells, place the formula into the leftmost active cell, then press CSE.
This will fill the selected range with the contents of the defined range.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Stephen Francis M" wrote:
I have created a name range for monthly sales (Jan thro to Dec) for each
product. Example Name Sales_Prod1_06 which applies to cells N12:y12. On a
summary worksheet I now want to reference this range and enter
=Sales_Prod1_06. However I get Value! error if the name range is not entered
in column N:y on the summary worksheet.

I am sure I was able to do this without any probelm in the old version of
excel ( I am now using 2007)

Thanks for your help