Macro Mondays – How To Convert Your Excel Macro To An Excel Add In
Hello Excellers, it is indeed time for some more #macromonday fun. Today I am going to share with you how to take your Excel Macro, and turn it into an Excel Add In. If you have created a an...
Hello and welcome again to #formulafriday. Time for some more formula fun on a Friday. Today we will be looking at using the NETWORKDAYS Function to work out how many days are left in a month...
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...
Formula Friday – How To Quickly Identify A Circular Reference In An Excel Sheet.
Hi Excellers, welcome back to another blog post in my #formulafriday series. Today let's look at locating circular references in Excel really easily. Why would we need to do that?. Well, chances...
Formula Friday – How To Calculate Age From A Date Of Birth In Excel
Hi Excellers, time for some more #formulafriday fun. Again this week this blog post is based on a question I was asked by a subscriber a few weeks ago and I thought it would be a good share it on...
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...