| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
enter named range as opposed to cell ref.
I built a range reference called REND. I placed it in cell W9 to see how it
worked. i.e. W9 is =REND. Result is S9:S$50. Tried to use it in another formula cell. {=MAX(VALUE(SUBSTITUTE(INDIRECT(REND),"5:","")))} #VALUE error {=MAX(VALUE(SUBSTITUTE(INDIRECT(W9),"5:","")))} works I don't want to use the cell for this purpose so I used the name dialog box to insert the formula REND. Why?? -- GeneS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
enter named range as opposed to cell ref.
It's a quirk of the INDIRECT function. I could try to explain it but it
doesn't make any sense and would probably just confuse you even more. It even confuses me and I'm supposed to know what I'm doing! -- Biff Microsoft Excel MVP "Gene" wrote in message ... I built a range reference called REND. I placed it in cell W9 to see how it worked. i.e. W9 is =REND. Result is S9:S$50. Tried to use it in another formula cell. {=MAX(VALUE(SUBSTITUTE(INDIRECT(REND),"5:","")))} #VALUE error {=MAX(VALUE(SUBSTITUTE(INDIRECT(W9),"5:","")))} works I don't want to use the cell for this purpose so I used the name dialog box to insert the formula REND. Why?? -- GeneS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Different answers when using cell references as opposed to actual | Excel Worksheet Functions | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| named cell range | Excel Worksheet Functions | |||
| Getting a named range from a cell value | Excel Worksheet Functions | |||
Hybrid Mode
