SUMIF CODE

[ezil]

What is wrong with this statement it igves "expected end of statement" error
msg.

sub abc()
pos=15
Range(Cells(3, 2), Cells(pos, 2)) = "=SUMIF(A2:A5,">10")"
end sub

 

[Dave Peterson]

Double up the double quotes in strings in your VBA code:

Range(Cells(3, 2), Cells(pos, 2)) = "=SUMIF(A2:A5,"">10"")"