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.
Therefore:
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
Bookmarks