Hello,
I had already applied validations to 400 cells before, but I just figured how to enhance it with restrictions/error messages, and now I'm hoping that there is a way that I can put in the 400 new validation formulas in a batch at once, perhaps by writing them in a column and indicating which cells they would belong to in the adjacent column and run a VBA code. Would something like that be possible? If so, it will save me an enormous number of hours
Thanks for any input!
I had already applied validations to 400 cells before, but I just figured how to enhance it with restrictions/error messages, and now I'm hoping that there is a way that I can put in the 400 new validation formulas in a batch at once, perhaps by writing them in a column and indicating which cells they would belong to in the adjacent column and run a VBA code. Would something like that be possible? If so, it will save me an enormous number of hours
Thanks for any input!
Last edited: