I was reading 7 formulas from a seriescollection in VBA (xlbubble
chart) . First four gave me A1-style formula, last three gave me R1C1
style formula. This messed up subsequent processing.

I used: ActiveChart.SeriesCollection(SeriesIndex).Formula

Nothing changed while running this from index 1 to 7.

Cause of this wonderful behaviour?

The last three chart series were added while the workbook had only one
sheet.
The first four were added while the workbook had more than 1 sheet.

Solution: add a second sheet to the workbook. All fomulas now come in
A1 style...

Very weird. Can't imagin this is by design. (Excel 2000 9.0.8948 SP-3)


Van: Charlie - profiel weergeven
Datum: vr 13 dec 2002 17:58
E-mailadres: "Charlie"
Discussiegroepen: microsoft.public.excel.charting

I have a scatter chart that I add points to existing
series.

I then parse the A1 chart formula to get the associated
range..
Everything works great up to around the 7-8 additional
point. then the formula(s),formulalocal, r1c1.. ALL CHANGE
TO R1C1 STYLE..

can anyone explain this or have a solution? a
recomendation (besides switching to third party charting
solution)

regards
Charlie B