It's Monday so must be time for some #MacroMonday Excel fun. Today I want to share with you a really handy Macro that will save a backup copy of your workbook with today's (or whatever date it is) date. How cool is that?. I use this a LOT. Making backups of your Excel file should be part of your usual spreadsheet routine. What Does The Macro Do? This Macro will save your Excel workbook to a new file with today's date as part of the filename. I love this, as I can find easily … [Read more...]
Macro Mondays – How To Remove All Hyperlinks From An Excel Workbook
Hello, Excellers. Welcome back t another #MacroMonday Excel blog post in my 2020 macro Series. I recently had this question submitted via email from a subscriber. How to remove all hyperlinks. They had a LOT of hyperlinks in an Excel workbook (with 50+ sheets). They needed to quickly delete the hyperlinks as they were no longer relevant. It is easy to remove multiple hyperlinks from a single worksheet, but removing hyperlinks from multiple worksheet tabs requires a little more work. … [Read more...]
A Formula To Check If You Have Extra Spaces In Your Data – Formula Friday
Welcome Excellers to another #FormulaFriday blog post in my 2020 Excel series. Today I am going to show you some Excel formulas. These are a great way to check if you have extra spaces in your Excel data that you need to clean up. Sometimes the data in cells looks identical like my barcodes in my sales extract. But, when you try to analyse the data you do not get the expected results. I will show you an example. I have a set of data below that I want to use in a VLOOKUP … [Read more...]
Insert Multiple Rows Into Excel. Macro Solution.
Hello, Excellers. Welcome back to another #MacroMonday #Excel blog post in my Excel Macro 2020 Series. Today I will show you how to insert Multiple rows into Excel. The user will specify how many rows to insert via an input box. This is a really flexible alternative solution to inserting a standard number of rows after each data containing data in Excel. So, it puts the user in full control of where and how many black rows to insert. Preparing To Write The Macro First, you … [Read more...]
Excel VBA Macro Code To Select Current Region In Excel.
Hello Excellers an welcome back to another #MacroMonday #Excel tip in my 2020 series. Today let's take alook at how to select the current region on an Excel worksheet with a simple Excel Macro. So, what is the Current Region on an Excel worksheet?. What Is The Current Region? The current region is a range of cells bounded by and combination of blank rows or blank columns. Let's take a look at some examples to explain, and see how this is really useful when we are writing … [Read more...]
- 1
- 2
- 3
- …
- 42
- Next Page »
Recommended Excel Resources
