Variable .FormulaArray

[helpexcel]

I'm using code to place this formula in the column A of a spreadsheet. Usually the code will update itself for each row, however this formula remains the same for every row. Any ideas why?

Range("A3:A" & LastRow).FormulaArray = "=Index(Data1,Match(1,(Data2=$G3)*(Data3=$T3)*(Data4=$L3)*(Data5=$K3)*(Data6<>Worksheet!$D$4)*(Data6<>Worksheet!$D$5),0))"

Thanks!

 

[helpexcel]

Last one...

I'm getting an error on this one also...but it works when I manually input.

Range("A3").FormulaArray = "=IFERROR(INDEX(Data1,MATCH(1,(Data2=E3)*(Data3=R3)*(Data4=J3)*(Data5=I3)*(Data6<>Worksheet!$D$4)*(Data6<>Worksheet!$D$5),0)),INDEX(Data1,MATCH(1,(Data2=E3)*(Data3=R3)*(Data4=J3)*(Data5=I3),0)))"

 

[Marcelo Branco]

The formula seems ok. What error are you getting?

M.

 

[helpexcel]

run-time error '1004': Unable to set the FormulaArray property of the Range class

 

[Marcelo Branco]

Worked for me. Don't know why is not working for you

M.