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?