Macro Mondays -Creating and Updating Your Personal Macro Workbook
Hello Excellers, welcome to another #macromonday blog in this series. Today let's look at saving macros to a personal macro workbook to reuse in any workbook when you start Excel on your...
Hello, Excellers. Today's blog post in the #formulafriday continuing series is a little bit different. Usually, we discuss formulas, it is Friday after all! Today though we will discuss how to...
Hello Excellers. Welcome back to another #MacroMonday blog post. Today let's look at how to create a simple Excel VBA Macro which will be useful for converting your data to uppercase on your...
Combine Conditional Formatting With An Excel Formula – Identifying Duplicate Values
Hello Excellers, welcome back to another blog in the #formulafriday series. Today let's look at how to combine conditional formatting with an Excel formula. What are we going to achieve...
Hello, Excellers. Today's blog post is a coffee break quick Excel tip for you. So, I was recently asked how to make Excel worksheet tabs stand out by changing their tab colour. In particular,...
Remove All Data Connections From An Excel Workbook Using VBA – Excel Macro
Hello, Excellers, welcome back to another #macromonday blog in this series. Glad to have you back. Today let's look at removing all data connections from an Excel workbook. Why would you want...