Formatting SUMPRODUCT

  • Thread starter Thread starter Floyd
  • Start date Start date
F

Floyd

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.
 
Hi Floyd,
I apologize for asking so many questions the last two
Click to expand...
days. All of my

Why should you? Isn't that what a newsgroup exists for?


Application.SumProduct(--Range(Rng1Addr), --Range
Click to expand...
(Rng2Addr))

Try

SumProduct = Application.WorksheetFunction.SumProduct(Range
("A1", "A3"), Range("B1", "B3"))

Best

Markus
 
Back
Top