Category Archives for "VBA"

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

Continue reading


How to Avoid the Select Method in VBA & Why

The first TV I remember us having as a kid did NOT have a remote control.  How inconvenient, right?

Every time someone in the family wanted to change the channel or volume, we had to get up off the couch and walk over to the TV to press a button.  You didn’t want to be the one sitting closest to the TV unless you needed some exercise… 🙂

The Select Method is Like Using a TV without a Remote Control

Continue reading