View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brett
 
Posts: n/a
Default Please Help!! Macro error

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,I NDEX(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!