An Excel VBA Macro To Convert All Formulas To Values – Macro Mondays
Hi, Excellers welcome to another blog post in the #macromondays series. Today, let' s look at saving a tonne of time. Sounds good right?. We will write an Excel VBA macro which will convert all...
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...