Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
series objects; finding specific ones in the collection
I asked this before but I'm still not clear on it.
When ever I wish to create a new series, no big deal: Dim SeriesRandTarget As Series Set SeriesRandTarget = myChart.SeriesCollection.NewSeries As long as I have the object, I can use it. If I set the name attribute as in SeriesRandTarget .Name = "Hello" I can collect it later if needed by: Set myseries = myChart.SeriesCollection("Hello") But what about this? What is the new series name I just created in the below example? (The macro recorder has me in this fix!) myChart.SeriesCollection.Paste Rowcol:=xlColumns, SeriesLabels:=False, _ CategoryLabels:=True, Replace:=False, NewSeries:=True The next recorded step is myChart.SeriesCollection(4).Select I tried slipping in Name:="My Name", but it croaks. How do you find this series? thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
series objects; finding specific ones in the collection | Charts and Charting in Excel | |||
Number of objects in a collection | Excel Programming | |||
Passing Objects from Excel VBA collection to a VB6 DLL | Excel Programming | |||
Help needed in finding specific series via row. | Excel Worksheet Functions | |||
Range objects in a collection | Excel Programming |