I have a macro that clears the contents of a range of cells every day, but after the macro runs, it resets the cell lock feature to default.
I would ideally like to set the font, font size, and cell lock features of all the cells to be cleared daily, without having these settings messed with. Anyone know the best way to accomplish this?
The code is simple...
Please Login or Register to view this content.
Welcome to the forum!
The following change will just clear the value or formula without affecting any other settings:
However, looking overall at what you are doing I would recommend this code. There is no need to loop if you are going to clear every nonempty cell. This is much faster. There is also no need to mess with calculation:Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks