Forum Discussion
Solved
using vba to enter a unique function formula
i can enter a simple formula in a cell and it works fine =unique(items[item]) if i use vba to enter the formula, it does not spill and only A1 gets filled range("A1").Formula = "=unique(items[i...
The Formula property cannot handle dynamic array formulas. Use Formula2 instead:
Range("A1").Formula2 = "=unique(items[item])"
The Formula property cannot handle dynamic array formulas. Use Formula2 instead:
Range("A1").Formula2 = "=unique(items[item])"
ok, hans. thank you very much