Error 2029. How do I fix this error
 

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

whe
c.Value="INDIANAPOLIS IN"
c.Offset(0, 1)="ZAYO BANDWIDTH"

Error 2029. How do I fix this error
 

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
---------------
Jacob Skaria


"Ayo" wrote:

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

whe
c.Value="INDIANAPOLIS IN"
c.Offset(0, 1)="ZAYO BANDWIDTH"

Error 2029. How do I fix this error
 

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

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Ayo" wrote:

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

whe
c.Value="INDIANAPOLIS IN"
c.Offset(0, 1)="ZAYO BANDWIDTH"

Error 2029. How do I fix this error
 

You can post it online using one of these free posting websites...

http://www.mediafire.com/
http://www.freefilehosting.net/
http://savefile.com/

--
Rick (MVP - Excel)


"Ayo" wrote in message
...
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

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Ayo" wrote:

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

whe
c.Value="INDIANAPOLIS IN"
c.Offset(0, 1)="ZAYO BANDWIDTH"

Error 2029. How do I fix this error
 

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...


"Ayo" wrote:

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

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Ayo" wrote:

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

whe
c.Value="INDIANAPOLIS IN"
c.Offset(0, 1)="ZAYO BANDWIDTH"