Macro Monday – Why Is My Personal Macro Workbook Not Loading Automatically?
Today's blog post is an answer to a common question I receive. Why is my Personal Macro Workbook not loading automatically in Excel?. I had this problem recently also. All was going well....
Hello, Excellers. Welcome to #MacroMonday again. Today, I will demonstrate the process of renaming an Excel Macro. For some reason, you may need to rename one of your Excel Macros...
Macro Mondays – Create A Macro To Schedule An Automatic Backup Of An Excel File When You Close It.
It is time again for some more #macromonday fun. Today I want to share with you a really useful Macro that will schedule an automatic backup at whatever time you choose of your Excel...
Macro Mondays – Insert A The Number Of Rows Into Excel Worksheet Specified By The User.
Hello Excellers and time for some more #macromondays VBA fun. Today, I will show you how to write a Macro to insert extra rows into your excel worksheet. The number of rows will be variable,...
Macro Mondays -Save A Back Up Copy Of Your Excel Workbook With Today’s Date
It's Monday so must be time for some #MacroMonday Excel fun. Today I want to share with you a really handy Macro that will save a backup copy of your workbook with today's (or whatever date it...
Macro Mondays – Convert A Range Of Cells To Upper Case With An Excel Macro
Hello, Excellers. Welcome back to another #MacroMonday blog post in my #ExcelTips series for 2021. You may or may not already know how to convert all text to upper case in Excel by using the UPPER...