FormulaArray with existing cell

[Michael Singmin]

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

 

[Frank Kabel]

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

 

[Tom Ogilvy]

Or even
Range("C6").FormulaArray = Range("C6").Formula

to do it in C6.

 

[Frank Kabel]

Or even
Range("C6").FormulaArray = Range("C6").Formula

to do it in C6.

thanks Tom - C6/D6 nearly the same
regards
Frank

 

[Michael Singmin]

Once again this group delivers the goods.

Thanks Frank k & Tom

MIchael
===============================================