Excel VBA Array Function - Easy Excel Macros

The Array function in Excel VBA can be used to quickly and easily initialize an array. Place a command button on your worksheet and add the following code lines: 1. First, create a variable named departments of type Variant. Dim departments As Variant 2.

www.excel-easy.com