Thread: Sumproduct instead of SumifS in VBA (application.sumproduct)
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
AB[_2_] AB[_2_] is offline
external usenet poster
  
Posts: 236
Default Sumproduct instead of SumifS in VBA (application.sumproduct)
That applies to all the functions you use - also the .index
Did you make that change too?
As far as I know the only way to reference/use genuine Excel Worksheet
functions is via the:
application.worksheetfunction.
construct.
So, did you make that other change too?


On Dec 30, 12:48*pm, Majken Bilslev-Jensen
wrote:
Makes no difference....

Reply With QuoteReply With Quote