zljordan
05-20-2014, 11:23 AM
Hello All,
I am trying to create macro that can dynamically name and update named ranges that are being used in dependent data validation lists on a different page. Thus far, I have only been able to dynamically create the level of the data validation, and keep getting an error message when I attempt to select the dependent variable.
I have attached the following workbook to give you a better idea of what I am trying to do.
Thank you,
Zac
I am trying to create macro that can dynamically name and update named ranges that are being used in dependent data validation lists on a different page. Thus far, I have only been able to dynamically create the level of the data validation, and keep getting an error message when I attempt to select the dependent variable.
I have attached the following workbook to give you a better idea of what I am trying to do.
Thank you,
Zac