Hi I keep getting a "run time error 1004 unable to set the formulaarray property of the range class" at this point in my VBA...I can't seem to figure out why:
I read about the character limit of 255, but from what I see this is only 241 so doesn't seem to be that, any help would be appreciated!
Code:
Set wsout = ActiveSheet
wsout.Range("BS59").FormulaArray = "=IFERROR((INDEX(EC$2:EC$9999,MATCH(1,(OFFSET(A$1,MATCH(BO59,AE$2:AE$199,0),0)=EA$2:EA$9999)*(BU$1=EB$2:EB$9999),0))/INDEX(EC$2:EC$9999,MATCH(1,(OFFSET(A$1,MATCH(BO59,AE$2:AE$199,0),0)=EA$2:EA$9999)*(EOMONTH(BU$1,-1)=EB$2:EB$9999),0)))-1,"""")"
I read about the character limit of 255, but from what I see this is only 241 so doesn't seem to be that, any help would be appreciated!