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]
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]