Hello all...
I have a data validation dropdown created through a unique filter on another sheet. This particular dropdown is to schedule drivers for a dispatch company, and so I created a filter that removes drivers who are already on trips during that time. The dropdown checks the dates for the trip and looks at only available drivers.
It works awesome, except that it presents a problem. When selecting the driver that is available, that driver is immediately removed from the list by the filters, and the data validation error display for the cell. The item is no longer in the list.
I would like to write code to mimic the user clicking the ignore error on that cell, but have not been successful in finding out how. I think I just don't have the language on these types of errors by which to search Google. Can anyone help?
I tried a bunch of things, the last being this... which didn't work...
GaryApplication.Range("E3").validation.ShowError=false
Reply With Quote