Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop gone crazy | Excel Discussion (Misc queries) | |||
Do Loop | Excel Discussion (Misc queries) | |||
Help with Do...Loop | Excel Discussion (Misc queries) | |||
hysteresis loop | Charts and Charting in Excel | |||
loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) |