Macro Mondays – How To Write A Macro To Close All Of Your Workbooks At Once
Hello Excellers time for some more #macromonday fun! This week again I wanted to share with you some code that saved me a tonne of time, a really small piece of code, but with big benefits. This...
Macro Mondays – Copy Excel Rows From One Worksheet To Another Worksheet Based On Criteria Using VBA
Hello Excellers, time for some more #MacroMonday fun. Today's Macro will allow you to quickly copy rows of data from one worksheet to another. This can be really useful if you carry out the same...
Macro Mondays – A Macro To Create An Alert When A Cell Value Exceeds Its Target Value
Hello Excellers, time for some #macromondays fun again. Today I want to share with you a really small piece of code, that will alert the user when a cell value reaches or exceeds a it's target...
Macro Mondays – How To Print All Excel Workbooks In A Folder Using An Excel Macro
Hi Excellers in today's Macro Monday let's look at creating a Macro to print all of the Excel workbooks in a folder. If you have a bunch of workbooks in an Excel folder and you need print all of...
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...