V
Viktor Ygdorff
I want to change the series of existing charts. As I do it now (and it works
but with some problems) I just assign new values. Perhaps it is better to use
Replace/substitute? I have never used them and the help function in vba is in
some foregin language. Please if you know how to use them help me out? Me
code the charts series replacement is:
Do While k < (UBound(rng))
If Not IsEmpty(rng(k)) Then
ActiveChart.SeriesCollection(varWorksheetInfoArray(k)).Values =
Sheets(varWorksheetInfoArray(0)).Range(rng(k).Offset(i, 0).Address & ":" &
rng(k).Offset(j, 0).Address)
Else: End If
k = k + 1
Loop
but with some problems) I just assign new values. Perhaps it is better to use
Replace/substitute? I have never used them and the help function in vba is in
some foregin language. Please if you know how to use them help me out? Me
code the charts series replacement is:
Do While k < (UBound(rng))
If Not IsEmpty(rng(k)) Then
ActiveChart.SeriesCollection(varWorksheetInfoArray(k)).Values =
Sheets(varWorksheetInfoArray(0)).Range(rng(k).Offset(i, 0).Address & ":" &
rng(k).Offset(j, 0).Address)
Else: End If
k = k + 1
Loop