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
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