Hello Excellers. Welcome back to another #MacroMonday blog post. Today let's look at how to create a simple Excel VBA Macro which will be useful for converting your data to uppercase on your...
Category: Macro Mondays
Remove All Data Connections From An Excel Workbook Using VBA – Excel Macro
Hello, Excellers, welcome back to another #macromonday blog in this series. Glad to have you back. Today let's look at removing all data connections from an Excel workbook. Why would you want...
How To Write A Macro To List All Files In A Folder – Macro Mondays
Hello, Excellers I am excited to share with you some cool VBA Macro fun. I find this a really useful macro which uses the Excel For Loop to list all files in a folder or directory. Similarly, we...
An Excel Macro That Will Copy An Entire Worksheet To Another Workbook – Macro Mondays
Hi Excellers, welcome back to another instalment of #macromonday. Let's look at how to save a tonne of time by writing a simple Excel VBA Macro that will copy an entire worksheet from one Excel...
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. ...