Highlight Misspelled Words In Excel With A Simple VBA Macro – Macro Mondays
Hello and welcome to your weekly instalment of #macromonday. A great way to learn how to write Excel VBA macros. Today we will let's look at mistakes, or being more specific misspelled words. ...
How To Find The Minimum Number In A Excel Data Set – Two Formula Options – Formula Friday
Hello Excellers and welcome to my regular blog spot of #formulafriday. Today is really a double edition as I show you two great ways to find the minimum number in an Excel data set using two Excel...
A VBA Excel Macro Which Will Export And Save Each Worksheet As A Separate PDF – Macro Mondays
Hello Excellers and welcome back to my regular blog spot of #macromonday. Today, I want to show you how to write a simple Excel VBA macro which will convert to PDF then export and save each of...
How To Create A Variable Drop Down List In Excel – Formula Friday
Hello Excellers and welcome to another #formulafriday blog post. Today let's look at how to create a variable drop-down list in Excel. That's right to be able to choose a value from one cell, and...
Display An Pop Up Message To Users Opening An Excel File – Macro Monday
Welcome, Excellers and time for another #macromonday. Today I want to share with you how to display we welcome (or any other message) on your Excel workbook when it is opened. I use this small...
Defer Data Updates In Your Excel Pivot Table. – Pivot Table Tip
Hello, Excellers. Today I want to show you a really quick Excel Pivot Table tip that might be very useful for you if you are updating or making changes to a large Pivot Table. You may already...