FormulaArray with existing cell

  • Thread starter Michael Singmin
  • Start date
M

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
 
F

Frank Kabel

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

Michael Singmin

Once again this group delivers the goods.

Thanks Frank k & Tom

MIchael
===============================================
 
Top