Macros & VBA

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

How to Unhide and Rehide Multiple Sheets in Excel

July 31, 2019

Select vs Activate in VBA for Excel

Difference Between Select and Activate Methods in VBA

July 25, 2019

Text to Time Values - Solution 4 - UDFs VBA 640 Thumb

Convert Text to Time Values with UDFs in VBA

June 5, 2019

User Defined Functions UDFs in Excel with VBA 640

How to Write User Defined Functions (UDFs) in Excel with VBA

May 29, 2019

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