Add cell value to email subject line

So I tried adding the same procedure to my Inspections workbook. Kinda the same principle but we are dealing with Inspections and Days Remaining Till as opposed to Engines and Hours Remaining Till. In the workbook, I have a form that feeds data into a database (Past Inspections). The List sheet pulls the latest record for each Inspection category and is used to as a dashboard to see when the next inspection is due. I want to use the Days to Go column just the way we used the Hours column in the hoursexample workbook. Adapting the code to this workbook sounded a lot easier than it is turning out to be. I was trying to fix one error at a time until it all worked out but have hit a roadblock with the current "Object Required" error that is popping up...