Clear contents of unlocked cells, but some of them are merged

New to the forum. I am trying to clear data on specific sheets & specific cells in my excel workbook. I am currently using the code below because some of the cells I need cleared are merged and it works great so far but it clears all the unprotected cells on the entire workbook. The clearcontents code would not work for me because of my merged cells. How can I edit this code to only clear the unprotected cells on specific sheets? I have one sheet I need to leave unprotected but I do not want this data cleared.

Please Login or Register  to view this content.

Administrator's note: Please take the time to review our rules. There aren't many, and they are all important. Our guidelines recommend code tags. I have added them for you this time because you are a new member. --6StringJazzer

Most people here would tell you to avoid using merged cells. They cause lots of problems. I'll look for 6Stringjazzer's post that lists quite a lot of them for you.

It would be easier to help if we could see how your data is organized and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.

Originally Posted by MattyT92

I am trying to clear data on specific sheets & specific cells

Which sheets and which cells? Same cells on each sheet, or different cells for different sheets?

Bear in mind that the name test is case-sensitive as written. To avoid that you could use something like:

Please Login or Register  to view this content.