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?

INDIRECT and Defined Names
 

To achieve a relative reference with
INDIRECT you have to use R1C1 notation like this
=SUM(INDIRECT("R[-12]C",FALSE),INDIRECT("R[-12]C[1]",FALSE))


regards
Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"Tevuna" wrote in message
...
It appears that the INDIRECT function is inconsistent with a relatively
defined name.
I've 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 it's being entered. This is inconsistent with the
INDIRECT behavior, which is evaluating text to reference, because "Right"
represents a reference.
Any insight?