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

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

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

to do it in C6.

--
Regards,
Tom Ogilvy


"Frank Kabel" wrote in message
...
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

Tom Ogilvy wrote:
Or even
Range("C6").FormulaArray = Range("C6").Formula

to do it in C6.


thanks Tom - C6/D6 nearly the same :-)
regards
Frank

Once again this group delivers the goods.

Thanks Frank k & Tom

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