Error 2029. How do I fix this error


A

Ayo

c.Offset(0, 2) = Evaluate("=SUMPRODUCT(--('BO Download'!$B$" & DIregion_sRow
& ":$B$" & BOReport_lastRow & "=" & c.Value & "),--('BO Download'!$F$" &
DIregion_sRow & ":$F$" & BOReport_lastRow & "=" & c.Offset(0, 1) & ")," & _
"--('BO Download'!$H$" & DIregion_sRow &
":$H$" & BOReport_lastRow & "=""Selected""))")

c.Offset(0, 2)=Error 2029

where:
c.Value="INDIANAPOLIS IN"
c.Offset(0, 1)="ZAYO BANDWIDTH"
 
Ad

Advertisements

J

Jacob Skaria

Try the below..

c.Offset(0, 2).Formula = Evaluate("=SUMPRODUCT(" & _
"('BO Download'!B" & DIregion_sRow & ":B" & BOReport_lastRow & _
"=""" & c.Value & """)*" & "('BO Download'!F" & DIregion_sRow & _
":F" & BOReport_lastRow & "=""" & c.Offset(0, 1) & """)*" & _
"('BO Download'!H" & DIregion_sRow & ":H" & _
BOReport_lastRow & "=""Selected""))")

If this post helps click Yes
 
A

Ayo

I am having a bigger problem that that. Is there somewhere I can send the
file to you so that you can take a look at the rest of the code for me? Thanks
 
Ad

Advertisements

J

Jacob Skaria

I have tried the below formula and it works for me.

OR else try your original formula with slight changes...Please note the
change in double quotes in my formula...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top