Hi people!
i have some rows of data and i whant to make 1 chart per section of data.
the "sectios" are 100rows x 5columns.
i have a problem with my script:
this is the part i recorded as makro:
ActiveChart.SetSourceData Source:=Sheets("alle vergleiche_Export gesamt"). _
Range("A102,N102:R102,A104:A486,N104:R486"), PlotBy:=xlColumns
the problem i have is how to let the columns "grow" in a loop?
i tryied to use cells within Range(), but i don't get it to work. Then i tryied to use a simple string in Range(myString), and define myString like this:
how can i let MyColumn1 and MyColumn2 grow each loop? this variables are strings, containing a character (or 2, as soon as i get over z to aa ab,...)myString = "A102," & MyColumn1 & "102:" & MyColumn2 & "102 , A104: A486 ," & MyColumn1 & "104:" & MyColumn2 & "486 "
how can i make MyColumn1 = MyColumn1 + 5????
thank you very much!!!
Bookmarks