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...
Archives: Blog
Formula Friday – Insert The Current Filename And Path In A Cell Using the CELL Formula
So, hello Excellers, welcome my first #FormulaFriday #Excel blog post in my 2020 series. Welcome if you are new to my blog and welcome back if you are a regular reader. Today let's look at a...
Export To PDF. How To Save A Selected Excel Range As A PDF File. Macro Monday
Hello Excellers and welcome to another #macromonday in my #Excel 2020 series. Thanks for joining me again and let’s save some more time with a handy Excel VBA macro. Today we will explore how...
Formula Friday – Calculate Only Some Of Your Workbook’s Formulas
Hello Excellers and welcome to another #Excel #formulafriday blog in my 2020 series. Today I want to address an issue that happens a lot with Excel workbooks that have become too large and...
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...