View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Singmin Michael Singmin is offline
external usenet poster
 
Posts: 60
Default FormulaArray with existing cell

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