Hi Michael
if I understood you correctly try
Range("D6").FormulaArray = Range("D6").Formula

--
Regards
Frank Kabel
Frankfurt, Germany

Michael Singmin wrote:
Hello Group,

Can one use FormulaArray on an existing text structure?

For example, if C6 contains
=INDEX(INDIRECT($J$5),MATCH(A12&B12,INDIRECT($J$6) &INDIRECT($J$7),0))
can I turn this into {CSE} using FormulaArray on C6 ?

Or should I use Sendkeys ?

Thanks,

Michael Singmin