![]() |
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