Welcome back Excellers to another #MacroMonday blog post in my #Excel 2020 series. Today let's write an Excel VBA macro to count files in a folder. I have used this macro regularly when I am...
Tag: Macros
Hello Excellers and welcome to another Excel #Excel tips #MacroMonday bog post in my 2020 macro series. Today I want to share with you a simple macro. This small bit of code will clear all cells with...
Hello Excellers and welcome back to another #MacroMonday #Excel blog post in my 2020 series. Do you want to quickly create a backup of your Excel workbook in the same folder as your original...
Hello Excellers and welcome back to another #MacroMonday #ExcelVBA blog post in my 2020 series. Have you ever needed to convert a whole folder of Excel files into CSV files? Me too!. Just last...
Hello Excellers, welcome back to another #MacroMonday #Excel blog post in my 2020 series. Today, I want to share with you today a handy Excel VBA macro. This macro will delete any leftover black...
Hi Excellers and welcome back for another #MacroMonday in my 2020 series. I use this small find and replace Excel macro on a regular basis. It will replace values or sales value with 1. Any...