Clear Content Macro won't run

This is wrong to start with...

Please Login or Register  to view this content.

You cannot start another procedure without terminating the previous one with an 'End Sub' or 'End Function'

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

I am in hopes I fixed as asked. I clicked on #as instructed and saved but am not seeing any changes. Please advise. I will visit the rules also. Thank you

Rig manager
Once you change your thread title, as requested, I'll give you a nice 8 line piece of code that does the same as your code.

Thank you. I greatly appreciate any help. I attached the work book the code if for. Hope that helps anyone that may take the time to help. Again thanks in advance to all.

Jolivanes, Thank you very much. That code does work. I can't get it to work with protection on though. Would you have some insight on that? I really need to learn how to write code. Yours is so much easier. Again thank you.

I never have protection on. But I would say that the reason for protecting a sheet is that it cannot be changed. However, it needs to be changed, that is what the code is all about.
If you want to have protection, at the beginning of the code you can have a line to unprotect the sheet, need password of course, and at the end a line to protect again.

If it is only for the one sheet, this should do it. I have not tried this though.
Keep in mind that if the code generates a problem that the sheet will be left in unprotected state until you protect it again.
In this case, RigMan will be your password. Note capitals and small letters.

Please Login or Register  to view this content.

BTW, I think it might be a good idea to have a folder with Templates of all the excel files you're going to end up with.
If you do that, you don't really have to worry about clearing the sheets. Just open your template that should have all the formulas etc in it.

Absolutely. I have a master copy of every spread sheet I build. I've done good with the calculations after I figure out the computer language. Have to re-learn that when I go on a tangent to build a new sheet. The Macro is a whole new beast to me. Again thanks for your help. I'm sure I'll be bugging ya a lot.

Well, sounds like you have it under control.
Good luck I would say and we'll see you here again.