Hello all

Is there a trick to put an array formula with curly brackets {} into a cell through VBA. If entered manually I would CTRL+SHIFT+ENTER, but not sure how to do it from VBA?

Example, I need to enter a formula I define in sResult into a cell, but it has to be entered as an array with {}

sResult = "INDEX(C$3:C$13,SMALL(IF((B$3:B$13=C$16)*(D$3:D$13=C$18),ROW(C$3:C$13)-ROW($C$2)),ROW($A1)))"
Cells(1, 1).Value = sResult