Attention localized users: Dynamic named range not showing in list

  • Thread starter Thread starter count
  • Start date Start date
C

count

Hi,
I'm using Excel 2002 version localized for Poland.
When named range is asked to self-dimension itself, using OFFSET as
described in:
http://www.contextures.com/xlNames01.html#Dynamic
and in here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;830287&Product=xl2002
then it behaves oddly:
1. It does not show in Names box (top left)
2. It allows for simple Data... Validation (List.... =MyDynamicRange) BUT
3. It does not work for dependant data validation, through use of INDIRECT,
as described here:
http://www.contextures.com/xlDataVal02.html
Can you confirm this problem existing in other languages too?
TIA - Paul
 
Hi Paul,

A dynamic range name is a name containing a formula.
Names containing formulae dont show up in the Names box.
Also INDIRECT cannot evaluate a name containing a formula or a formula
string, only strings that are references.


Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com
 
Hi Paul,

The article you quote can be misunderstood,
You do not need RAND to make dynamic named ranges update, OFFSET is already
a volatile function.

The only problem is INDIRECT which does not evaluate formulae.

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com
 
Back
Top