Thread: Using SUMPRODUCT in VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marcotte A Marcotte A is offline
external usenet poster
  
Posts: 66
Default Using SUMPRODUCT in VBA
I want to use the sumproduct function to calculate a value in my macro. I
need to use the "--" format of the function. Is this syntax correct?

myVar = application.worksheetfunction.sumproduct(--(myRange=OtherVar),
AnotherRange)
Reply With QuoteReply With Quote