Hi All,

I am working on a workbook which has over 100 worksheets. In each of these worksheets, there is 12 form control drop downs, which I need to change the input range for (the input range is that same for each drop down). Does anyone know if there is a way to change the input range of all of the drop downs at once, rather than me spending hours and hours changing them one by one???

Thanks in advance.