Fill cell with a value from List Validation applied

Hello all,
I'm working on a macro that checks if list validation rule is applied to a cell and if it is empty, fill its content from one of the values available in the list.
I'm currently facing a problem that the setting of up of value is applied even if there is no list validation rule applied to it.
My sample data in a worksheet

Header
List validation rule Applied but empty
List validation rule Applied but empty
List validation rule Applied but empty
.
.
.
Header
List validation rule Applied but empty
List validation rule Applied but empty
List validation rule Applied but not empty
.
.
.

Header
List validation rule Applied but empty
List validation rule Applied but empty
List validation rule Applied but empty
.
.
.


The problem is even though list validation rule is not applied to headers, the value is applied to them. I would like to know a way to stop this.

Please Login or Register  to view this content.

Sorry for cross posting. I'm marking this as solved as I've opened it on the other community mrexcel.

Don't crosspost!!!