Macros & VBA

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

7 Hidden Buttons That Make Excel Easier to Use

Charts & Dashboards, Macros & VBA, Tips & Shortcuts

7 Hidden Buttons That Make Excel Easier to Use

July 15, 2026

Macro Recorder and ChatGPT

Macros & VBA

Automate Excel with VBA and ChatGPT

May 7, 2025

Macros & VBA

5 Excel Macros I Use Every Day to Save HOURS

March 26, 2025

Macros & VBA

Run a Macro on a Protected Sheet in Excel

October 22, 2024

Table of Contents

Macros & VBA

Table of Contents Macros

May 3, 2023

how-to-search-data-validation-lists-in-excel-cover-640x360

Macros & VBA

How to Search Data Validation Drop-down Lists in Excel

January 18, 2022

XLOOKUP Go To Source Macro

Formulas, Macros & VBA

Go To Source Cell of XLOOKUP Formula

January 20, 2021

3 Ways to Fill Down Blank Cells

Formulas, Macros & VBA

3 Ways to Fill Down Blank Cells in Excel

October 21, 2020

VBA Macro to Create Power Query Connections for All Tables

Macros & VBA, Power Pivot/Query/BI, Power Query

VBA Macro to Create Power Query Connections for All Excel Tables

May 27, 2020