vba loop
 

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

vba loop
 

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

vba loop
 

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

"Jackie" wrote:

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

vba loop
 

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....
--
Jackie


"L. Howard Kittle" wrote:

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

vba loop
 

this worked perfect! thank you so much!
--
Jackie


"bpeltzer" wrote:

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

"Jackie" wrote:

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