vba loop

J

Jackie

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!
 
L

L. Howard Kittle

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
 
B

bpeltzer

You need to create a string that would like just like the formula as if you
typed it:
ActiveCell.Formula = "=sumif(e2:e30000, " & i & ",j2:j30000)"
--Bruce
 
J

Jackie

it repeats the formula sumif(e2:e30000,i,j2:j30000) ten times ..?.. instead
of adding all the 1's (and putting the total in 1 cell) , then all the 2's
(putting the total in the second cell, all the 3's etc....
 
Top