Hi,

I need a macro written that will check each cell in a worksheet and if it has a drop down list in it, then I need the Ignore Blank checkbox on the Data Validation menu to be unchecked. I need this to repeat so that all cells on the worksheet are checked, and repeat for all worksheets in the active workbook.

I should also mention that not every cell has a drop down, this will be used for multiple workbooks in the future, and I need it ASAP.


Any help would be GREATLY appreciated.


Thanks,

V