Maybe the cells that were once unprotected are somehow changed to protected?
You can also place this in your code:
Code:
ActiveSheet.Unprotect
then at the end of your code:
Code:
ActiveSheet.Protect
You may want to make sure that you are indeed clearing data from unlocked or unprotected cells.