| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Defined Names in Workbook
Rather than referencing a range for a given Name, I have typed in a formula,
which typically works. However, I have noted that when using a formula that includes other named ranges, I get the #VALUE error. Is there a way around this, or is it simply a weakness in Excel? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Defined Names in Workbook
Can you give more details so we can experiment?
-- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Beaniecounter" wrote in message ... Rather than referencing a range for a given Name, I have typed in a formula, which typically works. However, I have noted that when using a formula that includes other named ranges, I get the #VALUE error. Is there a way around this, or is it simply a weakness in Excel? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Defined Names in Workbook
Yes, I'm new to this so I apologize. I have a named range called CurrMo,
which references Row 1 of the worksheet, each successive cell containing dates as follows: 1/1/07, 2/1/07, and so on. In addition to using the CurrMo reference in a large formula I have created, I also need to make reference to the month following the current month (CurrMo). In order to do so, I defined a Name in the workbook using a formula rather than a range, calling it NextMo. The formula is as follows: =Date(Year(CurrMo),Month(CurrMo)+1,1) Typically, using a formula to define a Name works fine. But in this instance, and in others, when I use another named range rather than actual cell references, the #VALUE error is returned. "Bernard Liengme" wrote: Can you give more details so we can experiment? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Beaniecounter" wrote in message ... Rather than referencing a range for a given Name, I have typed in a formula, which typically works. However, I have noted that when using a formula that includes other named ranges, I get the #VALUE error. Is there a way around this, or is it simply a weakness in Excel? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Defined Names in Workbook
Post an example of a formula that is returning #VALUE!.
-- Biff Microsoft Excel MVP "Beaniecounter" wrote in message ... Yes, I'm new to this so I apologize. I have a named range called CurrMo, which references Row 1 of the worksheet, each successive cell containing dates as follows: 1/1/07, 2/1/07, and so on. In addition to using the CurrMo reference in a large formula I have created, I also need to make reference to the month following the current month (CurrMo). In order to do so, I defined a Name in the workbook using a formula rather than a range, calling it NextMo. The formula is as follows: =Date(Year(CurrMo),Month(CurrMo)+1,1) Typically, using a formula to define a Name works fine. But in this instance, and in others, when I use another named range rather than actual cell references, the #VALUE error is returned. "Bernard Liengme" wrote: Can you give more details so we can experiment? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Beaniecounter" wrote in message ... Rather than referencing a range for a given Name, I have typed in a formula, which typically works. However, I have noted that when using a formula that includes other named ranges, I get the #VALUE error. Is there a way around this, or is it simply a weakness in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| defined names | Excel Worksheet Functions | |||
| Defined names | Excel Worksheet Functions | |||
| Tranferring names defined in one excel workbook to another workboo | Excel Discussion (Misc queries) | |||
| How to delete all defined names from a workbook? | Excel Worksheet Functions | |||
| How to delete all defined names from a workbook? | Links and Linking in Excel | |||
Linear Mode
