VBA Multiply Cells in one Range by Cells in Another

Please Login or Register  to view this content.

I'd like to modify the above code so that all the cells in "BV:CF" are multiplied by their corresponding values in "Z:AJ." The cells are consecutive, so BV3*Z3, BW3*AA3, BV4*Z4, ect. I'd like for this to be reflected in the end sum in column CH. Help??