View Single Post
 
Old 02-18-2016, 11:35 PM
ufopilot ufopilot is offline Windows XP Office 2007
Novice
 
Join Date: Oct 2015
Posts: 6
ufopilot is on a distinguished road
Default

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.
Reply With Quote