Hi Jackie,
Quick guess, did not test.. drop the "i" to i only???
In quotes I do think it is looking for text.

HTH
regards,
Howard

"Jackie" wrote in message
...
Hi all, I need your expertise ...
here's what I am doing:

Dim i as Integer
For i = 1 to 10
ActiveCell.Formula = "sumif(e2:e30000, "i",j2:j30000)"
ActiveCell.Offset(0,1).select
Next i

I want this to run through 10 times and also use the value of "i" in the
formula. ie: its first time through it looks for 1 then 2 then 3 ... I
can't seem to get it to recognize i as a variable instead it just looks
for i
in the columns.

I appreciate your help!

--
Jackie