for loop in excel macro

[Li Chen]

Hi all,

Here is an off -Ruby topic. Recently I need to do a lot of work in Excel
with repeated work. And macro might be some help.
I wonder how I can loop some ranges of cells using a for loop in
Excel.

Thanks,

Li


For i =0 To 4 Step 1
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlColumnClustered
ActiveChart.SetSourceData Source:=Range("A11,A22")

MsgBox i
Next


###############################
after each step the following line should change as follows:

Range("A11,A22")

Range("A11,A33")

Range("A11,A44")

.....

 

[Rodrigo Bermejo]

Hi all,

Here is an off -Ruby topic. Recently I need to do a lot of work in Excel
with repeated work. And macro might be some help.
I wonder how I can loop some ranges of cells using a for loop in
Excel.

Thanks,

Li


For i =0 To 4 Step 1
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlColumnClustered
ActiveChart.SetSourceData Source:=Range("A11,A22")

MsgBox i
Next


###############################
after each step the following line should change as follows:

Range("A11,A22")

Range("A11,A33")

Range("A11,A44")

.....

You can perform this task using Ruby.
You can find plenty of info about right here:

http://rubyonwindows.blogspot.com/search/label/excel


Then the required loop can be implemented in the ruby way you are used
to.

 

[Li Chen]

You can perform this task using Ruby.
You can find plenty of info about right here:

http://rubyonwindows.blogspot.com/search/label/excel


Then the required loop can be implemented in the ruby way you are used
to.

Hi Rodrigo,


Thanks for the link. I might refer it if I use a lot of Excel
automation. But I need a quick method for my project immediately. I
just get some help from VBA group in Yahoo:

Range("A11,A" & i + 2 & "" & i + 2)


Li