Hi Guys,


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

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


Code:
--------------------


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


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



Can anybody Please suggest some solution?

Thanks,

MHR


--
Malhar
------------------------------------------------------------------------
Malhar's Profile: http://www.excelforum.com/member.php...o&userid=36343
View this thread: http://www.excelforum.com/showthread...hreadid=561287

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

"Malhar" wrote:


Hi Guys,


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

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


Code:
--------------------


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


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



Can anybody Please suggest some solution?

Thanks,

MHR


--
Malhar
------------------------------------------------------------------------
Malhar's Profile: http://www.excelforum.com/member.php...o&userid=36343
View this thread: http://www.excelforum.com/showthread...hreadid=561287