F
foilfencingandy
I'm using Jon Peltier's code to modify strings within charts;
For Each mySrs In ActiveChart.SeriesCollection
strTemp = WorksheetFunction.Substitute(mySrs.Formula, OldString,
NewString)
mySrs.Formula = strTemp
How do I use a similar approach to change strings for the error bar ranges?
I'm having trouble referring to the error bars, and don't know how to define
myError (dim mySrs as Series - what's the equivalent?)
thanks,
Andy
For Each mySrs In ActiveChart.SeriesCollection
strTemp = WorksheetFunction.Substitute(mySrs.Formula, OldString,
NewString)
mySrs.Formula = strTemp
How do I use a similar approach to change strings for the error bar ranges?
I'm having trouble referring to the error bars, and don't know how to define
myError (dim mySrs as Series - what's the equivalent?)
thanks,
Andy