Hi There,

Array-formulas are incredibly useful ... although most people are
impressed with the power of it, they have serious difficulties to
understand that they need to rebuild them with CTRL+SHIFT+Enter.

Therefo

I would like to rebuild to be able to rebuild my Array-formulas
automatically. It jams though ..

Sub Rebuild_ArrayFormula()
Dim cells As Long, i As Long
Dim rngcel As Range

cells = Selection.Cells.Count
i = 1
For Each rngcel In Selection
rngcel.FormulaArray = rngcel.Formula '<====jams up here ...
Next
End Sub