So what did you want to do with the array ?
Did you want to sum it or just reference the whole array in one cell?


"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

Reference, otherwise you wouldn't need 12 cells...

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"CmK" wrote:

So what did you want to do with the array ?
Did you want to sum it or just reference the whole array in one cell?


"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

can you do that link 12 cells in one by name range wihtout &?
Just curious

"Wigi" wrote:

Reference, otherwise you wouldn't need 12 cells...

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"CmK" wrote:

So what did you want to do with the array ?
Did you want to sum it or just reference the whole array in one cell?


"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

What do you mean precisely, Cmk?

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"CmK" wrote:

can you do that link 12 cells in one by name range wihtout &?
Just curious

"Wigi" wrote:

Reference, otherwise you wouldn't need 12 cells...

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"CmK" wrote:

So what did you want to do with the array ?
Did you want to sum it or just reference the whole array in one cell?


"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

Hi Wigi

I didnt get what you meant by reference in your answer to my original question
"Reference, otherwise you wouldn't need 12 cells..."

If i name a range(a1:a99) as cmk
and reference it in cell B1 =cmk
whats that going to achieve unless he was trying to sum it like =sum(cmk)
This is refering to the original question of htis message group
"=Sales_Prod1_06. However I get Value! error if the name range is not entered
in column N:y on the summary worksheet. "

I hope i explained my self

Thanks
"Wigi" wrote:

What do you mean precisely, Cmk?

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"CmK" wrote:

can you do that link 12 cells in one by name range wihtout &?
Just curious

"Wigi" wrote:

Reference, otherwise you wouldn't need 12 cells...

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"CmK" wrote:

So what did you want to do with the array ?
Did you want to sum it or just reference the whole array in one cell?


"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