Macro will not record

[Rammy]

Hi All,

I have tried to do the following:

range("L2").arrayfunction = "=IF(ISNA(AVERAGE(G4:INDEX(G4:G13,MIN(ROWS(G4:G13),MATCH(9.99999999999999E+307,1/G4:G13)+1)))),0,AVERAGE(G4:INDEX(G4:G13,MIN(ROWS(G4:G13),MATCH(9.99999999999999E+307,1/G4:G13)+1))))"

But it does not compile. I thought if I used the Macro recorder I'd be able to figure out how to enter it into VBA, but it refuses to record when I hit ctrl+alt+enter.

Any ideas how to get this to compile?

Thanks!

 

[Andrew Poulsom]

It's FormulaArray not arrayfunction.