Cyberdude
05-11-2006, 11:45 AM
I?ve written a macro that will add a new Series to any of my charts. It works. However, in its present version, I do a user prompt to get the next available Series number to assign to the new Series being created.
I currently determine this number manually by inspecting the Series list in the Source Data dialog box before running the macro. To determine the next available Series number I visually count the number of existing Series in the Series list window of the diaglog box. If there are 6 names already there, then the next available one must be 7.
Are there any VBA statements I can use to count the number of Series names in that window. I have a rather complicated method involving a class module and chart events that I?d prefer not to use because I?d have to set it up for each of my workbooks.
I currently determine this number manually by inspecting the Series list in the Source Data dialog box before running the macro. To determine the next available Series number I visually count the number of existing Series in the Series list window of the diaglog box. If there are 6 names already there, then the next available one must be 7.
Are there any VBA statements I can use to count the number of Series names in that window. I have a rather complicated method involving a class module and chart events that I?d prefer not to use because I?d have to set it up for each of my workbooks.