To create a custom function in Excel VBA, you need to enable the Developer tab and go to the Visual Basic panel. Next, right-click on Microsoft Excel Objects > Insert > Module and enter the code.

VBA is a powerful program that enables non-programmers to create and edit macros. Learn how to enable & use VBA in Microsoft Excel.

You’ll use LAMBDA () functions the same way you use Excel functions. To demonstrate, enter the function and reference the values shown in Figure B, =SUBTRACTL (B3,C3).

The bare bones VBA code A simple list of sheet names is easy to generate using VBA thanks to the Worksheets collection. Listing A shows a simple For Each loop that cycles through this collection.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.