Help to DEBUG this line of code. Type mismatch error
Thanks Jacob. But why am I getting "#NAME?" for this line:
c.Offset(0, 2).Value = Evaluate("=SUMPRODUCT(--('BO Download'!$D$" &
startRow & ":$D$" & endRow & "=" & c.Offset(0, 1) & "),--('BO Download'!$E$"
& startRow & ":$E$" & endRow & "=" & c & "))")
c.Offset(0, 1)="DQE Communications"
c="NLP2"
"Jacob Skaria" wrote:
Try the below
c.Offset(0, 3) = Evaluate("=SUMPRODUCT(--('BO Download'!$A$" & _
startrow & ":$A$" & endrow & "<""""),--('BO Download'!$D$" & _
startrow & ":$D$" & endrow & "<""""),--('BO Download'!$E$" & _
startrow & ":$E$" & endrow & "<""""))")
If this post helps click Yes
---------------
Jacob Skaria
"Ayo" wrote:
'c.Offset(0, 3) = Evaluate("=SUMPRODUCT(--('BO Download'!$A$" & startRow &
":$A$" & endRow & "<" & "" & "),--('BO Download'!$D$" & startRow & ":$D$" &
endRow & "<" & "" & "),--('BO Download'!$E$" & startRow & ":$E$" & endRow &
"<" & "") & ")"
|