Hey Excellers. Today I will show you how to use the Find and Replace in Excel. Specifically to replace exactly only the values you need to. This blog post is in response to a question a...
Tag: Excel Tips
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...
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...
Happy Friday Excellers. Welcome back to another #FormulaFriday #Excel blog post in my 2020 Excel series. Today I want to share with you an old function in Excel that you can't really find any...
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...