Unable to Rid Of Cell Validation

[Ark68]

I have a cell with a list type cell validation, and I am unsuccessful with getting rid of it with this code.

With ws_staffrec.Range("H6")
      .Validation.Delete
End With

After this code executes, the drop down list of the validation still exists. How do I get rid of the validation?

 

[Fluff]

Are you pointing to the correct cell & sheet? As that code should remove the data validation.

 

[Ark68]

Yes. It is the both the correct sheet and cell. Could it be because the cell is a merged cell Fluff?

 

[Fluff]

Very possibly, what happens if you unmerge it?

 

[Ark68]

Hello Fluff,
Yes ... that was indeed the problem. I had to unmerge before I could delete the validation, and remerge.

Thanks for the support.

 

[Fluff]

You're welcome & thanks for the feedback.

Yet another reason to avoid merged cells like the plague