Need to clear just the cell and not the entire row. Here is the code that needs changing.


[VBA] With ThisWorkbook.Sheets("Holidays")
.Rows.EntireRow(i + 1).ClearContents[/VBA]