VBA Macro: Plugging an Array-Formula into a Cell and Dragging Formula Down Columns

When using an array-formula, the user (via Windows) must press Shift+Ctrl+Enter for Excel to calculate.

How do you do this using VBA? In addition, how do you force Excel to calculate the formula if you were to drag the original cell downward?

=Index(Range,Match(Cell1&Cell2,Range2&Range3,0))

The solution turned out to be something rather simple.

Range("Cell3").FormulaArray = "Index(Range,Match(Cell1&Cell2,Range2&Range3,0)) "

Watching carefully, I noticed that Excel was systematically processing each cell had the array-formula in it. Now that was tricky part, which led me to the solution, forcing me to realize that all data needs to be in place for it to calculate properly.