I need a macro that can if possible, remove a data validation and set it to any
so i can input any values in a cell without the error..

good suggestions will surely get a star =)