JimS
10-24-2010, 08:18 AM
I have several Named Ranges that are referenced when using the Indirect formula "(=INDIRECT(A2)" as the Data Validation source. This works fine.
When I converted the Named Ranges to Dynamic Ranges "(=OFFSET(Data!$M$2,,,COUNTA(Data!$M:$M)-1)" to accommodate for new entries in each list the Indirect Data Validation no longer works. It will not display the list in the range.
Can Dynamic Ranges be referenced by Data Validation?
Thanks for any help…
JimS
When I converted the Named Ranges to Dynamic Ranges "(=OFFSET(Data!$M$2,,,COUNTA(Data!$M:$M)-1)" to accommodate for new entries in each list the Indirect Data Validation no longer works. It will not display the list in the range.
Can Dynamic Ranges be referenced by Data Validation?
Thanks for any help…
JimS