I'm trying to run a macro with the following formula in it:
Range("M2").Select
Selection.FormulaArray = _
"=IF(ISERROR(INDEX(R!A2:R5000,MATCH(LARGE(IF(R!A2:T5000=A2,R!Q2:Q5000),1),R!Q2:Q5000,0),14))=FALSE,INDEX(R!A2:T5000,MATCH(LARGE(IF(R!A2:T5000=A2,R!Q2:Q5000),1),R!Q2:Q5000,0),14),0)"
Everytime I run it, I get the "Unable to set the formulaArray property of
the range class " error". I thought I might have exceeded the 255 limit, but
the formula is only 181 characters!
Bookmarks