Changing series formula

[Ali]

Hello,

Im using the WorksheetFunction.Substitute code to change a series formula. But when a series sources data which is #NA, the code wont work, as the data is not visible on the chart. Anyway around this to change those series also?

many thanks ahead.

 

[Jon Peltier]

Ali -

Convert the series type to xlArea first, then you'll be able to access
the series.

- Jon