工作的VBA脚本，突然抛出错误？

The below code I have on an Excel sheet. I am using VBA to alter the contents of certain cells in order to format them correctly for my job. We keep a list of damages, bay locations, and VINs. Each one of these columns has their own certain formats, and for 2 of them I have working fine. Some of you may recognize some of this code from another post I had about getting the damage codes formatted correctly. The columns are ordered as suchThe below code I have on an Excel sheet. I am u