L
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("A1
1,A2
2")
MsgBox i
Next
###############################
after each step the following line should change as follows:
Range("A1
1,A2
2")
Range("A1
1,A3
3")
Range("A1
1,A4
4")
.....
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
MsgBox i
Next
###############################
after each step the following line should change as follows:
Range("A1
Range("A1
Range("A1
.....