re-instate one line:
EndTime = ThisWorkbook.Sheets("Scrubber").Range("D1").Value
If TypeName(EndTime) = "String" Then EndTime = TimeValue(EndTime)
should do it.