=INDIRECT(A1) where A1 contains a text representation of a defined range name. BTW the formula, =INDIRECT("range1") INDIRECT("range2"), will return the intersection value(s) of defined names 'range1' and 'range2'.
This message was edited by Mark W. on 2002-02-21 12:46