In my workbook called "Service Calendar 2018", I have a worksheet called "Intranet Calendar". I created a button on this sheet called Button 2. I want to click on this button and if the 1st sheet is last month, I would like for it to clear the cells B4:AF13 & B16:AF23, move the worksheet to the end of the workbook & rename it for the Month & year (ex. May '19). Anything that you can help with would be greatly appreciated. I have attached the workbook for your help!
Hi,
Here's one method
Note that there's a hidden sheet14 (December 2015) hence the "-1" in the Sheets.Count bit of code. If you remove the sheet then remove the "-1" as well.
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks