Category Archives for "VBA"

2 Keyboard Shortcuts to Select a Column with Blank Cells

Bottom line: Learn a few keyboard shortcuts to select all the cells in a column of the used range.  This is a solution for when the Ctrl+Shift+Down Arrow or Ctrl+Shift+End shortcuts don’t work.

Skill level: Intermediate

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Continue reading


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