I have been using this routine to Find and Replace source data in charts.
http://peltiertech.com/Excel/Charts/ChgSrsFmla.html
I am trying to modify it to Find and Replace Error Bars.
Im coming up against a brick wall though, as I cant return the Error Bar range.
Since I cant return it, I cant find and replace it .
Anyone know how to do this?
