Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
In the Charts collection, there is an Add function. In the object browser, the add function is described as follows€¦ Function Add([Before], [After], [Count]) As Chart By doing some experimenting with code text I learned that when using €śAdd€ť I can also specify a name for a chart if I use the following text which is not shown in the Object browser, and does not show up as a prompt when I enter the text. Chart_Name_for_My_New_Chart = €śMyChart1€ť Charts.Add.Name = Chart_Name_for_My_New_Chart I tried the same approach with Charts.Delete, without success. I tried€¦ Chart_Name_for_My_Old_Chart = €śMyChart1€ť Charts.Delete.Name = Chart_Name_for_My_Old_Chart So this brings me to two questions. First, how might I have discovered the Charts.Add.Name code language using the documentation or the object browser, and Second, is there any corresponding, but seemingly undocumented code I can use with Charts.Delete to delete one specific chart? Thanks very much. Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Object Browser Icons | Excel Discussion (Misc queries) | |||
Adding a DLL to Excel (2003) Object Browser | Excel Programming | |||
Object Browser does what? | Excel Programming | |||
Object Browser Help | Excel Programming | |||
Object Browser Help | Excel Programming |