I'm writing a long program to analyze my lab's financial data.

I created a subprogram that I want to copy into the longer program. The
subprogram calculates an array of subtotals using the SUMPRODUCT command

total = ActiveSheet.Evaluate("SUMPRODUCT((" & myRng1.Address & _
"=""" & myVar1 & """)" & "*" & myRng2.Address & ")")

It works fine, but I need to port this into the long program.
I copy/pasted the subprogram into my main program, but it hangs up at this
command. I've used debug.print to confirm all the variables and ranges in the
SUMPRODUCT statement, and the active sheet is the same.

I'm stuck. What else could be causing this statement to hang up?
--
Richard