Unable to set the formula property of the series class

[Malhar]

Hi Guys,


I am struggling with one problem. I am trying to change formulae o
series in a chart using VBA code given below. But I am getting

'Runtime Error 1004, Unable to set the formula property of the serie
class'


Code
-------------------


ActiveChart.SeriesCollection(1).Formula = _
Replace(ActiveChart.SeriesCollection(1).Formula, "Sheet1", "test")


-------------------



Can anybody Please suggest some solution?

Thanks,

MH

 

[RBee]

Malhar....did you ever find a solution to this? I'm having same issue.
Thanks!