Macros & VBA

Add-in, Macros & VBA

How to Uninstall and Remove an Excel Add-in

January 27, 2020

13 comments

Formulas, Macros & VBA

VLOOKUP CHOOSE vs INDEX MATCH Performance Test

September 25, 2019

24 comments

Formulas, Macros & VBA

VLOOKUP Assistant – Preview

August 21, 2019

123 comments

Macros & VBA

How to Unhide and Rehide Multiple Sheets in Excel

July 31, 2019

8 comments

Macros & VBA

Difference Between Select and Activate Methods in VBA

July 25, 2019

19 comments

Macros & VBA

Convert Text to Time Values with UDFs in VBA

June 5, 2019

4 comments

Macros & VBA

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

May 29, 2019

17 comments

Macros & VBA, Tips, Tips & Shortcuts

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

April 10, 2019

25 comments

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

How to Sort Drop Down Lists Automatically in Excel

February 6, 2019

10 comments