Hello
I can acquire the formula of a series in a chart if the values sourced are valid figures, but when im sourcing to values which are all #NA(), so not visible on the chart, i can seem to acquire the formula of that series?? anyway round this? apart from changing the #NA() to zero's.

many thanks ahead?

Ali -

Try first to change the Series.ChartType to xlArea. Then you can access
the .Formula and the .Values, .XValues, and other properties.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Ali wrote:

Hello,
I can acquire the formula of a series in a chart if the values sourced are valid figures, but when im sourcing to values which are all #NA(), so not visible on the chart, i can seem to acquire the formula of that series?? anyway round this? apart from changing the #NA() to zero's.

many thanks ahead?

Thanks for that. I would never have thought of that! Cheers!

ps your website is great. and was really informative for excel VBA.nice one!