| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FOR loop macro
Error:
Unable to set the value propoerty of the series class Please help me fix this error? Thanks The code I use is sub chart () Charts.Add ActiveChart.ChartType = xlXYScatter ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A45:F63000"), PlotBy:= _ xlColumns For i = 1 To 10 j = ((i - 1) * 524) + 46 k = j + 523 ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(i).XValues = "='Sheet1'! R46C3:R569C3" ActiveChart.SeriesCollection(i).Values = "='Sheet1'!R(" & j & ")C1:R(" & k & ")C1" '''''''''''' Error here ActiveChart.SeriesCollection(i).Name = "=Sheet1'!R(" & j & ")C2" Next |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Do until loop with use of another macro in loop | Excel Programming | |||
| how can i loop a macro | Excel Discussion (Misc queries) | |||
| loop macro | Excel Programming | |||
| Loop a macro | Excel Programming | |||
| VBA Macro Loop | Excel Programming | |||
Threaded Mode
