Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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 . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Message "user defined type not defined" | Excel Discussion (Misc queries) | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
Application-defined or object-defined error Please Help | Excel Discussion (Misc queries) | |||
Macro error : Application-defined or object-defined error | Excel Discussion (Misc queries) | |||
"User-defined type not defined" message in Excel | Excel Discussion (Misc queries) |