Count cells that have data validation

[benhodges]

How do I count the cells that have a data validation list?

In a column, I have some cells that have a data validation list and some cells that don't. I want to count the number of cells that have a data validation list. None of the cells contain values. They only contain text data.

My attempt was =COUNTIF(C2:C45, DataValidation)

This returned only 0, despite there being cells with a data validation list.

Just to be clear, I don't need to count the data that's in a data validation list, just the number of cells that have a data validation list.

Thank you.

 

[MickG]

You can count with code like this:-

MsgBox Columns("C:C").SpecialCells(xlCellTypeAllValidation).Count

 

[benhodges]

This worked great, thank you. Is there a formula I can use instead of a VBA code?