Attention localized users: Dynamic named range not showing in list

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
 
C

Charles Williams

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
 
C

Charles Williams

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top