Using VBA with array formulas

[DHS100]

I want to programmatically use VBA to enter an array formula but it seems
to be treating the like normal formulas. If I manually go to the cell and ctrl+shift+enter, it works. How do I do this?

.Offset(8, 1).FormulaArray = "=MIN(LEN(MyData1))"

many thanks in advance

 

[Andrew Poulsom]

This worked when I tried it:

Sub Test()
    With ActiveCell
        .Offset(8, 1).FormulaArray = "=MIN(LEN(MyData1))"
    End With
End Sub

The target cell contained an array formula.

Also, this returned the expected result:

MsgBox Evaluate("=MIN(LEN(MyData1))")