mardi 18 juillet 2017

Method 'FormulaR1C1' of object 'Range' failed

I'm having trouble running a macro in Excel (version 15 of 365 on Mac). It fails on this portion:

Dim LastRow2 As Long
LastRow2 = Range("A65000").End(xlUp).Row

Range("AV2").Select
ActiveCell.FormulaR1C1 = _
    "=IF(OR(AND(RC[-41]<>""ZZ"",RC[-27]=""I"",RC[-26]=""n"",RC[-40]<1),AND(RC[-41]<>""ZZ"",RC[-27]=""I"",RC[-26]=""n"",RC[-39]<1),AND(RC[-41]<>""ZZ"",RC[-27]=""I"",RC[-26]=""n"",RC[-38]<1),AND(RC[-41]<>""ZZ"",RC[-27]=""I"",RC[-26]=""n"",RC[-34]<1),AND(RC[-41]<>""ZZ"",RC[-27]=""I"",RC[-26]=""n"",RC[-33]<1),AND(RC[-41]<>""ZZ"",RC[-27]=""I"",RC[-26]=""n"",RC[-32]<1),AND(RC[" & _
    "ZZ"",RC[-27]=""I"",RC[-26]=""n"",RC[-31]<1),AND(RC[-41]<>""ZZ"",RC[-27]=""I"",RC[-26]=""n"",RC[-30]<1),AND(RC[-41]<>""ZZ"",RC[-27]=""I"",RC[-26]=""n"",RC[-29]<1),AND(RC[-41]<>""ZZ"",RC[-27]=""I"",RC[-26]=""n"",RC[-28]<1)),""Error"",""Good"")"
Selection.AutoFill Destination:=Range("AV2:AV" & LastRow2)

I can't figure out why...I don't see anything wrong with it. Any help would be appreciated.

Aucun commentaire:

Enregistrer un commentaire