I apologize for asking so many questions the last two days. All of my
Excel books are essentially useless for the questions that I have been
asking.

On top of this I don't understand the information that I have from
searching this group.

How can I format this in VBA?

Application.SumProduct(--Range(Rng1Addr), --Range(Rng2Addr))

This does nothing when executed.

Where Rng1Addr = "A1:A3" and Rng2Addr - "B1:B3" and both are defined as
Strings.

For reference: Rng1Addr = Rng1.Offset(-WorksheetFunction.Min(YearDelta,
Fac_Depr), 0) _
.Resize(WorksheetFunction.Min(YearDelta + 1, Fac_Depr + 1),
1).Address

Thanks in advance.