Can an array formula be included in VBA code?

**Aland2929** · 04-09-2013, 03:02 PM

I am getting an error on the 2nd row??

Range("AV3:AV3").FormulaArray = "=SUM(COUNTIFS(J:J,AT3,C:C,ExcludeCT))"
Range("AV3:AV3").Copy Range("AV3:AV & SecondLastRow - 1")

**Aland2929** · 04-09-2013, 03:12 PM

The error message is :Method range of Object Global failed

Thanks in advance

**Aland2929** · 04-10-2013, 12:10 AM

I think the problem is with the Paste part of the code but I can't figure it out? Would appreciate some help.
Thanks in advance

Re: Can an array formula be included in VBA code?