I have a cell with data validation set to a static list of values.
When the user selects a different cell, I want to deactivate the list
cell (lock it and disable in-cell dropdown). I have 2 columns that I
do this for. I can disable one, but not the other.

Range("N8:N12").Validation.InCellDropdown = False ' works
Range("H8:H12").Validation.InCellDropdown = False ' application or
object defined error

There is no difference in column H and column N, so why won't column H
work???

Thanks for anyone's help.