They say a picture is worth a thousand words
but.... this picture doesn't say anything about your macro nor what sheet you are working on.
If you haven't sorted this out yet, my guess is that you are on Sheet1 and that the sheet wasn't unprotected before the clearing of things in the macro.
Try something like this
Code:Sub ClearThings() With Sheets("Sheet1") .Unprotect Password:="mypassword" ' 'do your clearing of things here ' .Protect Password:="mypassword" End With End Sub
Bookmarks