welcome to the forum
Maybe you could trap them in a cell with worksheet event untill they add a value to the cell
It would perhaps be an idea to post a sample of your data - obviously dummy values that are confidential but ensure that your sample is an accurate reflection of what you're working with.
Bookmarks