| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SeriesCollection(2).Formula returns formula for series 1
This is really weird.
I've got a basic XY chart with 4 series on it. In VBA I'm having SeriesCollection(2).Formula and SeriesCollection(3).Formula both return the formula for series number 1. Series numbers 1 and 4 work ok. I tried changing the DisplayBlanksAs property, but it had no affect. Does anyone know why this would happen? It even does this in the immediate window, and in the Watches window. Restarting excel made no difference. I'm using excel 2003. Thanks, Brian Murphy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula returns error; abbreviating the formula | Excel Discussion (Misc queries) | |||
| How create a formula series with series inside | Excel Worksheet Functions | |||
| Excel Chart SeriesCollection Formula | Excel Discussion (Misc queries) | |||
| Help with Formula, returns #NAME! | New Users to Excel | |||
| Using SeriesCollection.Extend for a specific Chart Data Series | Excel Programming | |||
Threaded Mode
