From: Rodrigo Bermejo <rodrigo.bermejo@...>
Date: 2009-10-11T01:31:44+09:00
Subject: Re: for loop in excel macro

Li Chen wrote:
> 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("A1:D1,A2:D2")
> 
>     MsgBox i
>     Next
> 
> 
> ###############################
>   after each step the following line should change as follows:
> 
>   Range("A1:D1,A2:D2")
> 
>   Range("A1:D1,A3:D3")
> 
>   Range("A1:D1,A4:D4")
> 
>   .....

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.

-- 
Posted via http://www.ruby-forum.com/.