31
The For Next and For Each Loops Explained for VBA & Excel
Bottom line: The For Next Loops are some of the most powerful VBA macro coding techniques for automating common tasks in Excel. This article explains how the loop works to repeat actions on a collection of items, which saves us a ton of time with our jobs.
Skill level: Intermediate
22
Automatic Default Number Formatting in Excel Pivot Tables
Bottom line: Save tons of time by automatically formatting the numbers in the Values area of your pivot tables with a VBA macro. Number formatting is automatically applied when you drag a field into the Values area in one single step.
Skill level: Intermediate
14
3 Tips to Save and Close All Open Excel Workbook Files + Macro
Bottom line: Learn a few shortcuts and tips to save and close all open Excel workbooks.
Skill level: Beginner
8
The SUBTOTAL Metrics Macro – Create a Summary Table of All Function Types
Bottom line: The SUBTOTAL Metrics Macro creates a summary table with SUBTOTAL formulas for each calculation type in the SUBTOTAL function.
Skill level: Intermediate
10
VBA Code Modules & How to Run Macros Based on User Events
Bottom line: In this post we compare the different places to store macros, functions, & VBA code in Excel. We specifically look at the Code Modules, Sheet Module, and ThisWorkbook Module to learn the differences between how each works. We also learn how to run macros based on events or actions by the user.
Skill level: Intermediate
22
Preview of The Filter Mate Add-in for Excel
In the last webinar I mentioned a new add-in that I have been working on with Randy, a student of The VBA Pro Course. The add-in is called Filter Mate.
The goal of Filter Mate is to help make it easier to work with filtered ranges and Tables in Excel. I just recorded a quick video that gives a preview of how Filter Mate works.
Video: Preview of the Filter Mate Add-in
108
How to Search Data Validation Drop-down Lists in Excel
Bottom line: Learn a fast and easy way to search any data validation list or in-cell drop-down list with a free tool.
Skill level: Beginner
54
How to Add a Table of Contents Image Gallery Sheet to Your Excel Files
Bottom line: Make your hard work shine, and learn how to add a beautiful Table of Contents sheet to the front of your Excel workbook that contains clickable image tiles to each sheet in the workbook.
Skill level: Intermediate
26
Hide & Unhide (Filter) Columns with a Slicer or Filter Drop-down Menu
Bottom line: Have you ever wanted to use a slicer or filter to hide/unhide columns on a regular worksheet range or table? Normally our data has to be in a pivot table to make use of the column filtering capabilities, but this simple macro allows us to hide and unhide worksheet columns with a slicer or pivot table filter.
Skill level: Advanced
36
Excel Add-in Ribbon Disappears After Installation
Bottom line: A recent Microsoft Office security update has caused add-in Ribbon Menu Bars to disappear when Excel is opened. This article contains a few solutions for this issue.
