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
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