Find & Replace Within A Chart

[MCCCLXXXV]

I'm trying to write a function that goes through each data series in an active chart and finds and replaces relevant text in the =SERIES string. I've got the below so far, but it gives me an error at DataSeries.Formula = sNewDataStr. Any idea why?

Thanks!
-JR

Please Login or Register  to view this content.

[Andy Pope]

I assume the error is caused by the final formula being invalid.

Without seeing the variable content impossible to say.

[MCCCLXXXV]

Ha! As I was going to reply with the state of the variables right before the error hit, i realized that the type of sNewDataStr was variant/string (Cur was just string). I hadn't declared the sNewDataStr! So I did that and it worked lol. Thanks!