So, I looked around a found a bit of code and the good news is that it does cycle through all my sheets but I can't seem to actually make it clear all my unprotected cells.
I get an "application defined or object defined error". Maybe the issue is that I'm trying to clear contents on protected cells and that I need to find a way to not select the protected ones? I Read about a way to select all cells and then only select the ones that meet criteria -- something like ".selection.specialCells(xlCellTypeConstants, 23).Select " -- not sure if there's a way to make the criteria be unprotected cells?
Thanks in advance!
![]()
Please Login or Register to view this content.
Bookmarks