VBA - Strange behavior with Application.Evaluate and Sumproduct

[largebrick]

Hi All,

My first post here.

I have come across some unusual behavior in VBA with regards to Sumproduct when used in application.evaluate - I have posted some code below as an example:

=IF(([Daily_New.xlsx]Output!$L$2+0)-[Daily_New.xlsx]Output!$I$2>0,"",SUMPRODUCT((ROUNDDOWN([Database_new.xlsx]UserData!$T$2:$T$22815,0)=([Daily_New.xlsx]Output!$L$2+0))*([Database_new.xlsx]UserData!$E$2:$E$22815>=16)*([Database_new.xlsx]UserData!$E$2:$E$22815<=25)))

The strange behavior is that if I try to evaluate this with application.evaluate, it generates Error 2015, but if I paste it verbatim into the sheet, it calculates just fine.

Additionally, if I remove any one of the 3 conditions, and then do application.evaluate, again it works fine.

Is there some difference with the application.evaluate function in VBA that allows it to take only two Sumproduct conditions, despite the fact that it will work normally in the sheet?

Thanks for any assistance!

[romperstomper]

I think it's because your formula string is over 255 characters, not because of the complexity or number of functions per se.

[largebrick]

I just noticed that - thanks for your help.