Chart identification

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Tod was kind enough to supply me with this piece of code:

With ActiveSheet.ChartObjects("Chart 1")
.Activate
.Top = Range("C3").Top
.Left = Range("C3").Left
End With

Which enables me to move Chart 1 to cell C3. I need to correct this so that
I can move an already activated chart regardless of the chart id.

Thanks
The Doctor
 
With ActiveChart.Parent
.Top = Range("C3").Top
.Left = Range("C3").Left
End With
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No Data Lables 2
chart objects top 1
Chart datalabels linked to cells 1
Changing a horizontal axis crosses value using VBA 5
Problem with excel macro - getting automation error - URGENT 1
Print problems w/ charts excel 2003/2007 3
Chart disappearing in Excel 07 but not in 03 2
Positioning a chart on the worksheet 3

Back
Top