Quote Originally Posted by jmcilhinney View Post
A crash is an unhandled exception. You should do some debugging and examine the exception to see why it is being thrown and then you can address it. The fact that cell.Value.ToTitle() compiles suggests that you have Option Strict Off, so you should turn that On straight away. That would force you to cast the Value property, which is type Object, as type String. My suspicion is that you are allowing the cell to remain empty, in which case the Value would be Nothing and that, I think, would throw an ArgumentNullException when calling TextInfo.ToTitleCase.
The cell can't be null because it only happens when I try to change the cell and it has to pass the validation to get to the statement in question. Plus the db table the cell is tied to is not permitted to be anything but the three values. I will do more debugging I dont like not knowing why something breaks or doesn't produce the expected results.