Trying to clean up this code and use screen updating

Every time I try and clean up this code it only clears the cells on the first tab instead of all (Mon-Sun). Also I don't know why but I cannot get screen updating and GoTo Ring working. I don't like the flickering and want the code to return to active cell after running.

Here is the code, any help is GREATLY APPRECIATED!

Please Login or Register  to view this content.

Do a Google search on why one should not use select in Excel.
Let us know what you discovered and in the meantime I'll see to change your code.
I'll wait for your answer first though.

just guessing:

Please Login or Register  to view this content.

No need for screen updating and returning to original cell because nothing moves.

Please Login or Register  to view this content.

Ok I have been researching this. I am a novice and have issues with code when looping through multiple sheets. Going to try your code now, thank you for being patient

GOOGLE >> There are multiple issues with using .Select here:

The worksheet is not always specified. This happens if you don't switch worksheets while recording, and means that the code will yield different results for different active worksheets.
.Select() is slow. Even if Application.ScreenUpdating is set to False, this is an unneccessary operation to be processed.
.Select() is unruly. If Application.ScreenUpdating is left to True, Excel will actually select the cells, the worksheet, the form... whatever it is you're working with. This is stressful to the eyes and really unpleasant to watch.
.Select() will trigger listeners. This is a bit advanced already, but unless worked around, functions like Worksheet_SelectionChange() will be triggered.

OK that worked perfectly! Thank you guys!!

My apologies.
The thing I wanted to stress is that the use of "With.....End With" is preferred over selecting as you can see in both of our codes.
And of course all the other negative things you found out yourself.
Good luck and thanks for coming back to let us know.