ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   string replace for error bars (https://www.excelbanter.com/excel-programming/390344-string-replace-error-bars.html)

foilfencingandy

string replace for error bars
 
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


All times are GMT +1. The time now is 05:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com