Pete

That code could be looking for the string "00:00:00" rather than the numeric time value 00:00:00.

Also, it will be running on the active sheet as you have no worksheet reference.

Or it could be neither causing the problem.

Perhaps attaching a sample workbook would be a good idea.