Hello group,

I want to place in a cell C8 with VBA the statement
=Sumproduct((G3:G2500="w")*1)

Range("C8") = "=Sumproduct((G3:G2500="w")*1)"
Compile error, Expected: end of statement

Obviously, the inverted commas around w are causing the problem.
Is there a solution for this ?

I have a workaround of putting "w" in F1 and referencing F1 instead of
"w"

Thanks,

Michael Singmin