Macro Monday – How To Delete An Excel Worksheet If A Range Of Cells Is Empty
Hello Excellers, today let's look at how to delete all worksheets in an Excel workbook where a certain range of cells is empty. I use this piece of code every week on a report generated...
Macro Mondays – Mail Your Active Workbook As An Attachment With An Excel Macro
Hello Excellers, I am going to share what I think is one of my favorite Macros to date. It emails the active workbook as an attachment from Outlook. How often do you send the same updated...
Macro Mondays – How To Prevent A Workbook Closing Until A Cell Is Populated By The User
Hello Excellers and welcome to another Macro Monday blog post. Today let's look at forcing a user to populate a specific cell in the workbook before they are allowed to close it. If you want...
Macro Mondays -Open An Excel Workbook To A Specific Worksheet Tab
Hello Excellers, welcome to another blog post in my #MacroMonday series. Most Excel workbooks contain more than one worksheet, which can be helpful when you want to keep related data together....
Macro Mondays – Write A Macro To Set All Pivot Table Data Items To Sum
Hello, welcome to Macro Monday, and it is time for some more Macro fun. Have you noticed that when you create a Pivot Table, Excel by default will either SUM or Count your items. To read more...
Macro Mondays – Print All Sheets In An Excel Workbook – With Specified Exceptions
It's that time of week for some Macro fun, I love starting off the week with some code!. In Macro Monday last week we looked at printing specified worksheets in an Excel workbook, which in itself...