Macros & VBA

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

Gridlines Freeze Panes Lost in New Window Video Thumb 640

Macros & VBA, Tips, Tips & Shortcuts

Gridlines & Freeze Panes Settings Lost in New Window – How to Fix It

April 10, 2019

4 Ways to Automatically Sort Drop Down Lists Excel 640

Formulas, Macros & VBA, Power Pivot/Query/BI, Power Query, Tips, Tips & Shortcuts

How to Sort Drop Down Lists Automatically in Excel

February 6, 2019

How to Add Macro Buttons Video 640

How to Create Macro Buttons in Excel Worksheets

January 23, 2019

VBA Delete Rows Based on Condition YouTube Thumb 640

VBA Macro to Delete Rows Based on Cell Values

January 17, 2019

Copy Data to Another Workbook Using Macros Below Existing YouTube Thumb 640

How to Use VBA Macros to Copy Data to Another Workbook

January 9, 2019

Custom Keyboard Shortcuts to Select the First or Last Sheet in Excel

Macros & VBA, Tips, Tips & Shortcuts

Create Keyboard Shortcuts to Select the First or Last Sheet in Excel

October 17, 2018

Copy VBA Code to Other Workbooks Video Thumb 640

How to Copy or Import VBA Code to Another Workbook

October 11, 2018

Table of Contents Automatic Updates Video Thumb 640

Excel Table of Contents that Automatically Updates

September 26, 2018

Macro Buttons to Add Remove Fields to Pivot Tables

Macros & VBA, Pivot Tables

Macro Buttons to Add Fields to Pivot Tables

September 20, 2018