Clear vaidation

  • Thread starter Thread starter Hank Hendrix
  • Start date Start date
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
 
You can clear the contents of the data validation cells:

ActiveSheet.Cells _
.SpecialCells(xlCellTypeAllValidation) _
.ClearContents
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation Link to Color Coating 1
best way to validate data in forms; 2010 1
Data Validation List (conditional) 2
execute assigned data validation in vba? 11
Conditional Validation In Excel 1
Find Cell When Interior.ColorIndex =3 1
problems when removing validation 1
Dynamic view of data based on cell content 1

Back
Top