I need to clear constants in a range based on the value of a cell.



The values are 'yes' or 'no' (it is restricted by validation) and stored in
the first row (C1:AR1). If the value is 'no' all constants in the
corresponding column should be cleared from row 9 onward. The number of
rows is variable. A 'yes' value will not require any action.



I am using Excel 2002.



Thanks