Macro Mondays – Convert A Range OF Cells To ‘Proper’ Case With An Excel Macro
Hi Excellers, and welcome back to another #MacroMonday #Excel blog post in my 2020 macro series. It is time to sit up. We will be using the Proper Function today!. You may (or may not) know...
Hello Excellers and welcome back another #FormulaFriday #Excel blog post in my 2020 Excel series. I will share a solution to a question asked recently. How to find how many numbers in your list...
Formula Friday – Quickly Switch From Cell Values To View Formulas – An Excel Shortcut
Happy Friday Excellers!. Welcome to another #FormulaFriday #Excel blog post in my 2020 Excel series. I have a great tip for you. It is really short, but it allows you to quickly toggle...
Hello, Excellers welcome back to another #MacroMonday #Excel blog post in my 2020 Excel and VBA series. Do you do the same thing over and over again in Excel?. DO you want to get...
Formula Friday – Copy Formula Down When Formula Is Not Directly Next To Your Data Set
Hello Excellers, and welcome another #FormulaFriday in my #Excel 2020 series. I just love this Excel formula trick, It is a really quick way to copy a formula down a column when the formula is not...
Macro Mondays – How To Run An Excel Macro Automatically When You Open Your Excel Workbook
Hello Excellers and welcome back to another #MacroMonday #Excel blog post in my 2020 series. So, today I will show you a number of different ways to automatically run a VBA macro when you open...