Thread: SUMIF CODE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ezil ezil is offline
external usenet poster
 
Posts: 43
Default SUMIF CODE

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