Hello,

I previously had a post regarding dynamic Sumproduct, which I've managed to workout successfully through code. It puts in the formula, and pastes it as values.

HOWEVER, the data is 32,000 rows of data, and when the code tries to put the formula down 32k rows, it times out and I need to crash it. I waited over 60 min for it to finish, and it couldn't.

I've turned off screen updating and automatic calculations off while it attempts to run the code but still fails?? Is there any code that might help allow this to run, or is the formula just a pure memoy hog, and won't work???
[vba]
'.Range("L1") = "Time_Daily"
Set rColL = .Range(.Cells(2, "L"), .Cells(glForeMaxRow, "L"))
rColL.FormulaR1C1 = "=SUMPRODUCT((Fore_Switch_Int_Program=RC2)*(CALLS)*(Interval_Time)) _
/SUMPRODUCT((Fore_Switch_Int_Program=RC2)*(CALLS))"
rColL = rColL.Value 'turns to value
[/vba]