string replace for error bars

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top