Macro to Clearing Contents of Row affect Validation Lists

[Nathan Asius]

My Worksheet has a Form Control Button that controls a Macro which automates the clearing of contents of all cells in a row. I have these set up adjacent to 8 rows: 14-21. The cells in the rows affected are E14:AD14 consecutively through rows to E21:AD21
In two of those cells in each row, I have validation lists. One is a simple list. The other list is dependent so it contains a formula pulling the list from a helper cell on another worksheet.
When I press the button to run the macro, it seems the clearing of the cells has an effect on the validation list. It doesn't erase the drop down box in the cell. It only sometimes causes the dependent list to not drop down, where other times other lists do.

The Drop Down box affected occurs in rows M14 - M21. and the formula used in the Validation Box is
=IF(TrimClrSeries1="Galv",'Panel Spill Sheet'!$C41#,IF(TrimClrSeries1="Standard",'Panel Spill Sheet'!$C50#,'Panel Spill Sheet'!$C59#))
After clearing the contents on the rows, It seems the spill lists on the other worksheet 'Panel Spill Sheet' don't populate any longer.

TrimClrSeries1 is a named range on another worksheet.

Does anyone know what is the problem here and how to fix?