Clear vaidation

H

Hank Hendrix

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

Is it possible and how?
Thanks
Hank
 
D

Debra Dalgleish

You can clear the contents of the data validation cells:

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