Hello Excellers and welcome back to another #Excel #FormulaFriday blog post in my 2020 Excel series. Today I will show you how to conditionally format an Excel worksheet tab. This is useful if...
Tag: VBA
Count The Number Of Times A Workbook Has Been Opened. Macro Solution.
Hello Excellers, welcome back to another #Excel #MacroMonday blog post in my 2020 all things Macro series. Do you need to know how many times a workbook has been opened?. Would you like to know...
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...
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...
Macro Mondays – Create A Shortcut To Your Personal Excel Macro Workbook
Hello Excellers, welcome back to another #MacroMonday #Excel blog post. Today I will show you how to create a shortcut to your Personal Macro Workbook in Excel. Creating a shortcut to the personal...
Macro Mondays – Create A Simple Excel Macro To Delete All Named Ranges.
Hello Excellers and welcome to another #MacroMonday blog post in my 2019 series. I think that today's Excel VBA macro is a really useful one. I hope you find it cool too. If you have a lot of...