Link to home
Start Free TrialLog in
Avatar of Sonny G
Sonny G

asked on

Duplicated Validation tool in inserted column

I have a column with a data validation tool. When I insert a column between that column and the adjoining column, the new inserted column acquires the data validation tool! So, I now have two columns with the same feature! How can I either remove the data validation tool from the inserted column or how can I insert a new column without the tool.
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Another way.
  1. Select the column
  2. Go to Visual Basic
  3. Bring up the Immediate Window via ctrl+g
  4. Type "selection.clear" without the quotes into that window
  5. Press Return
Avatar of Sonny G
Sonny G

ASKER

Thanks, Martin!
You're welcome.