I have created an INDIRECT drop down list in cell B dependent upon cell A. Is there a function I can use to that will automatically clear the selection in cell B when cell A is changed? Hope that's clear.