The sheet protection won't let this happen. Your code needs to unprotectthe sheet, complete the operation, then protect it again. You can usethe macro recorder to generate the code to do this.