You can clear the contents of the data validation cells:

ActiveSheet.Cells _
.SpecialCells(xlCellTypeAllValidation) _
.ClearContents


Hank Hendrix wrote:
I have a sheet with several validation cells. I would like all validation
cells blank before any selections are made.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html