Macros & VBA

Learn how to write macros with the VBA programming language to automate common Excel tasks and complex processes.

Object Hiearchy in the House

Macros & VBA

Intro to VBA: The Excel Object Hierarchy (Part 2 of 3)

June 8, 2015

The Excel Object Model in VBA

Macros & VBA

Intro to VBA: Macros Explained in the Kitchen (Part 1 of 3)

June 8, 2015

Macros & VBA

Do You Use VBA?

June 1, 2015

VBA Methods to Find the Last Cell Row Column in Excel

Macros & VBA

VBA Tutorial: Find the Last Row, Column, or Cell on a Sheet

May 11, 2015

Mammoth Mountain Snowfall Dashboard

Add-in, Macros & VBA, Pivot Tables

PivotPal Bonus Videos: Learn PowerQuery, Unpivoting, VBA, & More

February 25, 2015

Unhide All Worksheets Using the VBA Immediate Window

Macros & VBA, Tips, Tips & Shortcuts

4 Ways to Unhide Multiple Sheets in Excel + VBA Tutorial

January 20, 2015

Table of Contents Add to Workbook2

Add-in, Macros & VBA

Tab Hound Features Update – Version 1.5

November 12, 2014

Create Concatenate Formula for Range of Cells with Concatenate Macro in Excel

Formulas, Keyboard Shortcuts, Macros & VBA, Tips & Shortcuts, Tools

How To CONCATENATE a Range of Cells + VBA Macro

October 24, 2014

Create Copy of Pivot Table and Convert to SUMIFS Formulas

Formulas, Macros & VBA, Pivot Tables, Tables & Data

Convert Pivot Table to SUMIFS Formulas – Free VBA Macro

October 14, 2014