Macros & VBA

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

Vlookup Choose vs Index Match

Formulas, Macros & VBA

VLOOKUP CHOOSE vs INDEX MATCH Performance Test

September 25, 2019

Vlookup Assistant Preview Thumbnail 2 640

Formulas, Macros & VBA

VLOOKUP Assistant – Preview

August 21, 2019

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