Need someone to look at this code line for me
 

I am getting a #Name? error and I have looked at this line so many times
over and I can't find anything that is remotely close to being or generating
an error like #NAME?.
I need someone else to take a look at this for me and see if they can find
the error.

Thanks

c.Offset(0, 4) = Evaluate("=SUMPRODUCT(--('BO Download'!$A$" & startRow &
":$A$" & endRow & "=" & marketName & "),--('BO Download'!$E$" & startRow &
":$E$" & endRow & "=C" & c.Row & ")," & _
"--('BO Download'!$G$" & startRow &
":$G$" & endRow & "<""""),--('BO Download'!$H$" & startRow & ":$H$" & endRow
& "=""A""))")

Need someone to look at this code line for me
 

Ayo wrote:
I am getting a #Name? error and I have looked at this line so many times
over and I can't find anything that is remotely close to being or generating
an error like #NAME?.
I need someone else to take a look at this for me and see if they can find
the error.

Thanks

c.Offset(0, 4) = Evaluate("=SUMPRODUCT(--('BO Download'!$A$" & startRow &
":$A$" & endRow & "=" & marketName & "),--('BO Download'!$E$" & startRow &
":$E$" & endRow & "=C" & c.Row & ")," & _
"--('BO Download'!$G$" & startRow &
":$G$" & endRow & "<""""),--('BO Download'!$H$" & startRow & ":$H$" & endRow
& "=""A""))")

I get #VALUE error.

Suggest you take the whole mess after Evaluate( , put it in a string,
and print it to the debug window you can see what is actually being
evaluated.

Need someone to look at this code line for me
 

That might depend on what's in the variable marketName.
If it's astring then you might need to change
& marketName &
to
& """"marketName"""" &
--
p45cal


"Ayo" wrote:

I am getting a #Name? error and I have looked at this line so many times
over and I can't find anything that is remotely close to being or generating
an error like #NAME?.
I need someone else to take a look at this for me and see if they can find
the error.

Thanks

c.Offset(0, 4) = Evaluate("=SUMPRODUCT(--('BO Download'!$A$" & startRow &
":$A$" & endRow & "=" & marketName & "),--('BO Download'!$E$" & startRow &
":$E$" & endRow & "=C" & c.Row & ")," & _
"--('BO Download'!$G$" & startRow &
":$G$" & endRow & "<""""),--('BO Download'!$H$" & startRow & ":$H$" & endRow
& "=""A""))")

Need someone to look at this code line for me
 

marketNAme is a string variable. I tried your suggestion & """"marketName""""
&
but that that only created a compile error


"p45cal" wrote:

That might depend on what's in the variable marketName.
If it's astring then you might need to change
& marketName &
to
& """"marketName"""" &
--
p45cal


"Ayo" wrote:

I am getting a #Name? error and I have looked at this line so many times
over and I can't find anything that is remotely close to being or generating
an error like #NAME?.
I need someone else to take a look at this for me and see if they can find
the error.

Thanks

c.Offset(0, 4) = Evaluate("=SUMPRODUCT(--('BO Download'!$A$" & startRow &
":$A$" & endRow & "=" & marketName & "),--('BO Download'!$E$" & startRow &
":$E$" & endRow & "=C" & c.Row & ")," & _
"--('BO Download'!$G$" & startRow &
":$G$" & endRow & "<""""),--('BO Download'!$H$" & startRow & ":$H$" & endRow
& "=""A""))")

Need someone to look at this code line for me
 

Thanks p45cal. & """marketName""" & worked instead.

"p45cal" wrote:

That might depend on what's in the variable marketName.
If it's astring then you might need to change
& marketName &
to
& """"marketName"""" &
--
p45cal


"Ayo" wrote:

I am getting a #Name? error and I have looked at this line so many times
over and I can't find anything that is remotely close to being or generating
an error like #NAME?.
I need someone else to take a look at this for me and see if they can find
the error.

Thanks

c.Offset(0, 4) = Evaluate("=SUMPRODUCT(--('BO Download'!$A$" & startRow &
":$A$" & endRow & "=" & marketName & "),--('BO Download'!$E$" & startRow &
":$E$" & endRow & "=C" & c.Row & ")," & _
"--('BO Download'!$G$" & startRow &
":$G$" & endRow & "<""""),--('BO Download'!$H$" & startRow & ":$H$" & endRow
& "=""A""))")