"Jello" wrote in message
...
If I may ask one more question, would there have been any way I could have
found the answer to this via the help files in the VB editor ? I notice
intellisense works for some words but not all e.g. ActiveSheet.
Or should I buy a book or go to a good Vb help/tutorial web site ?

Hi Jello,

Although a good book certainly won't hurt, one of the best ways to
figure out the Excel object model is by using the Object Browser. Press F2
in the VB Editor to bring it up. The ActiveSheet is typically a worksheet,
so if you scroll down the Object Browser classes list on the left side and
select the Worksheet object you'll see all the properties, methods and
events associated with a Worksheet on the right side. One of those methods
is the ChartObjects method, which you can use either to return a specific
ChartObject reference as in your original post, or loop to return a list of
all ChartObjects on the Worksheet as I showed.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm