| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT and Defined Names
It appears that the INDIRECT function is inconsistent with a relatively
defined name. Ive defined Right as referring to =!B1 while A1 was active. As expected, =Right, when entered directly into a cell, returns the value of offset one column. However, when I try INDIRECT (Right) the value of B1 is returned, regardless of what cell its being entered. This is inconsistent with the INDIRECT behavior, which is evaluating text to reference, because Right represents a reference. Any insight? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to keep names defined after a copy? | Excel Discussion (Misc queries) | |||
| NAMES DEFINED | Excel Discussion (Misc queries) | |||
| Defined names | Excel Discussion (Misc queries) | |||
| Rename Defined Names | Excel Worksheet Functions | |||
| Using non defined names from another sheet | Excel Worksheet Functions | |||
Threaded Mode
