| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Issue - Run time error 1004 | Excel Discussion (Misc queries) | |||
| MS Visual Basic Error...from MAcro | Excel Discussion (Misc queries) | |||
| Macro time out error | Excel Worksheet Functions | |||
| Macro / Compile Error / Duplicate Declaration | Excel Worksheet Functions | |||
| Runtime error for macro that works in workbook created in | Excel Discussion (Misc queries) | |||
Threaded Mode
