Formula Friday – How To Highlight All Cells That Contain A Formula Using ISFORMULA
Hello Excellers Happy Friday and it's time for some more #formulafriday fun. Today let's look at how to use the ISFORMULA function to achieve the following To test a cell reference to see if...
Formula Friday – 2 Ways To Create A Dynamic Named Range In Excel
Time for some more #formulafriday fun. Today let's look at 2 ways to create a name range in Excel. If you want to read more about using named ranges in your Excel formulas then you can read my...
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 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...
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...