Changing series formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Ali -

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

- Jon
 
Back
Top