Delete Validation From A Single Cell

JgiMitch · June 19, 2007, 12:52pm

Hi,

What is the easiest way to remove a validation from a single cell within a column that has a validation applied to the entire column.

Thanks In Advance,

Scott

amjad.sahi · June 19, 2007, 2:39pm

Hi Scott,

Well, you cannot directly remove validation from a cell within a range of cells. I think you can try to redefine your validation and its area.

Thank you.

Warren · June 21, 2007, 10:14pm

Hi Scott,

Please try the fix in <A href="</A>. If you want to remove a cell from the validation, please use Validation.RemoveACell() method. If you do not know which validation is applied for the cell, please use Validtions.RemoveACell() method.