Hello, Excellers. Welcome if you are new to my Excel Blog and welcome back if you are a regular reader. So, today I will show you how to comment out a block of Excel VBA Code. Or in other...
Category: Macros
Hello Excellers and welcome to another #MacroMonday #Excel blog post in my 2020 Excel and macro series. Today let's look at removing your Personal Macro Workbook from Excel. This workbook will...
Macro Mondays – Convert A Range OF Cells To ‘Proper’ Case With An Excel Macro
Hi Excellers, and welcome back to another #MacroMonday #Excel blog post in my 2020 macro series. It is time to sit up. We will be using the Proper Function today!. You may (or may not) know...
Hello, Excellers welcome back to another #MacroMonday #Excel blog post in my 2020 Excel and VBA series. Do you do the same thing over and over again in Excel?. DO you want to get...
Macro Mondays – How To Run An Excel Macro Automatically When You Open Your Excel Workbook
Hello Excellers and welcome back to another #MacroMonday #Excel blog post in my 2020 series. So, today I will show you a number of different ways to automatically run a VBA macro when you open...
Macro Mondays – A Simple Macro To Refresh All Data Connections When Opening An Excel Workbook
Happy Monday!, and it is Macro Time. Welcome to another #MacroMonday #Excel blog posts in my 2020 series. Today we will write a simple macro to refresh all data connections when your Excel...