#VALUE! when using defined name
 

HELP!!!
Problem: receive #VALUE! Using a defined NAME range
In workbook MonthlyBudget09Mstr.xlsx are sheets 1209Sch and 1209
1209Sch contains all monthly entries, 1209 is the summary sheet.

Defined name: HousingItems, ='1209Sch'!$L$83:$L$88, Values:
{"1";"2";"3";"4";"5";"15"} Workbook <<from Name Manager
L88 is a SUM function but I have remove L88 from range and still have problem

Placing =HousingItems in cell B4 of sheet 1209 results in #VALUE! Error
B4:B9 are empty

Can copy and then paste 1209Sch L83:L88 into B4 which fills B4:B9 with
correct values.

Please advise what I am doing wrong
Thanks
Rick

#VALUE! when using defined name
 

HousingItems is an *array* so you'd have to select a range of cells the same
size as HousingItems then array enter.

If you're just doing a simple cell link try this in B4 then copy down as
needed:

=INDEX(HousingItems,ROWS(B$4:B4))

--
Biff
Microsoft Excel MVP


"WAMTC" wrote in message
...
HELP!!!
Problem: receive #VALUE! Using a defined NAME range
In workbook MonthlyBudget09Mstr.xlsx are sheets 1209Sch and 1209
1209Sch contains all monthly entries, 1209 is the summary sheet.

Defined name: HousingItems, ='1209Sch'!$L$83:$L$88, Values:
{"1";"2";"3";"4";"5";"15"} Workbook <<from Name Manager
L88 is a SUM function but I have remove L88 from range and still have
problem

Placing =HousingItems in cell B4 of sheet 1209 results in #VALUE! Error
B4:B9 are empty

Can copy and then paste 1209Sch L83:L88 into B4 which fills B4:B9 with
correct values.

Please advise what I am doing wrong
Thanks
Rick

#VALUE! when using defined name
 

Biff
Thxs it worked and I understand to way it works.
Rick

"T. Valko" wrote:

HousingItems is an *array* so you'd have to select a range of cells the same
size as HousingItems then array enter.

If you're just doing a simple cell link try this in B4 then copy down as
needed:

=INDEX(HousingItems,ROWS(B$4:B4))

--
Biff
Microsoft Excel MVP


"WAMTC" wrote in message
...
HELP!!!
Problem: receive #VALUE! Using a defined NAME range
In workbook MonthlyBudget09Mstr.xlsx are sheets 1209Sch and 1209
1209Sch contains all monthly entries, 1209 is the summary sheet.

Defined name: HousingItems, ='1209Sch'!$L$83:$L$88, Values:
{"1";"2";"3";"4";"5";"15"} Workbook <<from Name Manager
L88 is a SUM function but I have remove L88 from range and still have
problem

Placing =HousingItems in cell B4 of sheet 1209 results in #VALUE! Error
B4:B9 are empty

Can copy and then paste 1209Sch L83:L88 into B4 which fills B4:B9 with
correct values.

Please advise what I am doing wrong
Thanks
Rick


.

#VALUE! when using defined name
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"WAMTC" wrote in message
...
Biff
Thxs it worked and I understand to way it works.
Rick

"T. Valko" wrote:

HousingItems is an *array* so you'd have to select a range of cells the
same
size as HousingItems then array enter.

If you're just doing a simple cell link try this in B4 then copy down as
needed:

=INDEX(HousingItems,ROWS(B$4:B4))

--
Biff
Microsoft Excel MVP


"WAMTC" wrote in message
...
HELP!!!
Problem: receive #VALUE! Using a defined NAME range
In workbook MonthlyBudget09Mstr.xlsx are sheets 1209Sch and 1209
1209Sch contains all monthly entries, 1209 is the summary sheet.

Defined name: HousingItems, ='1209Sch'!$L$83:$L$88, Values:
{"1";"2";"3";"4";"5";"15"} Workbook <<from Name Manager
L88 is a SUM function but I have remove L88 from range and still have
problem

Placing =HousingItems in cell B4 of sheet 1209 results in #VALUE! Error
B4:B9 are empty

Can copy and then paste 1209Sch L83:L88 into B4 which fills B4:B9 with
correct values.

Please advise what I am doing wrong
Thanks
Rick


.