ExcelBanter - Clear vaidation

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Clear vaidation (https://www.excelbanter.com/excel-programming/307021-clear-vaidation.html)

Hank Hendrix[_2_]

Clear vaidation

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

Debra Dalgleish

Clear vaidation

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

All times are GMT +1. The time now is 04:45 PM.