Hello Excellers, welcome back to another #Excel tip in my 2021 series. Today I will show you how to unprotect multiple Excel worksheets quickly. Have you created an Excel workbook with...
Tag: Blog
Find The First And Last Occurrence Of A Value With MINIFS and MAXIFS Functions.
Hello, Excellers. Today's blog post will show you how to find the first and last occurrence of a value. I recently used this method to query the first and last dates that a product appeared in my...
Hello Excellers, welcome back to another blog post in my #Excel #MacroMonday series. Today let's write our own Excel macro function that will generate a random string of characters. This random...
Hi, Excellers. Welcome back to another blog post in my new year of 2021 #MacroMonday Excel series. Today let's take a look at how to enable macros and also disable Macros in Excel....
Hi Excellers, and welcome back to another #Excel #MacroMonday blog post in my 2019 series. Today I want to show you how to write a quick and straightforward Excel VBA macro to highlight all...
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...