![]() Stepping through the code throws no errors or hints as to what goes wrong. The formula in the cell stays the same each time I run the macro. Do not enter the curly brackets yourself, Excel does it when you press CTRL+SHIFT+ENTER. TheFormulaPart3 = "COUNTIFS(Ratting!A:A,IF(COUNTIFS(Ratting!N:N,TRUE,Ratting!K:K,'Site Matrix'!A2)>0,"",INDEX(Ratting!A:A,MATCH('Site Matrix'!A2,Ratting!K:K,0))),Ratting!K:K,'Site Matrix'!A2)" To enter the array formula you must press CTRL+SHIFT+ENTER, that is hold down CTRL and SHIFT and then press ENTER releasing all of them together. TheFormulaPart2 = "SUMIF(Ticks!E:E,'Site Matrix'!A2,Ticks!C:C)/IF(COUNTIFS(Ratting!N:N,TRUE,Ratting!K:K,'Site Matrix'!A2)>0,"",1))" Here is what I have so far: Sub ArrayMacro() replace that the resulting formula was logical. I was very careful to make sure that in each stage of the. replace function is not replacing anything. I have looked online and found a promising solution of breaking the array into pieces and combining them again. ![]() I am trying to avoid the 255 character limit in entering an array formula through VBA.
0 Comments
Leave a Reply. |