I have the "Learn Excel 97 through Excel 2007 from MrExcel" book.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
I was successfully following the “Use Validation to Create Dependent Lists” on Page 900.<o
></o
>
Everything was working great.<o
></o
>
I then tried to use the “Allow Validation Lists to Automatically Redefine as They Grow” on Page 895.<o
></o
>
The “Allow Validation Lists to Automatically Redefine as They Grow” uses the =OFFSET(A1,0,0,COUNTA(A:A),1)<o
></o
>
To define the named range. The “Use Validation to Create Dependent Lists” uses the =INDIRECT( ) to pass the<o
></o
>
Result from the parent dropdown selection to the Validation source.<o
></o
>
<o
></o
>
This stopped working when I added the “Allow Validation Lists to Automatically Redefine as They Grow” from Page 895.<o
></o
>
<o
></o
>
Can you help?<o
></o
>




I was successfully following the “Use Validation to Create Dependent Lists” on Page 900.<o


Everything was working great.<o


I then tried to use the “Allow Validation Lists to Automatically Redefine as They Grow” on Page 895.<o


The “Allow Validation Lists to Automatically Redefine as They Grow” uses the =OFFSET(A1,0,0,COUNTA(A:A),1)<o


To define the named range. The “Use Validation to Create Dependent Lists” uses the =INDIRECT( ) to pass the<o


Result from the parent dropdown selection to the Validation source.<o


<o


This stopped working when I added the “Allow Validation Lists to Automatically Redefine as They Grow” from Page 895.<o


<o


Can you help?<o

