View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
DNF Karran[_14_] DNF Karran[_14_] is offline
external usenet poster
 
Posts: 1
Default Creating a Graph as an Object : Urgent!

How about when creating the chart assign to object var

sub CreateChart
dim chMyChart

set chMyChart = Charts.Add
....
....


You can then refer to the chart as a variable.

Other options include looping through all the chart objects in a sheet-
something like

Dim chMyChart

For Each chMyChart In ActiveSheet.ChartObjects
.....
Next
....

Duncan


---
Message posted from http://www.ExcelForum.com/