ActiveChart.Location help

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

Guest

Hi Guys,

In a macro I have the following line:

ActiveChart.Location Where:=xlLocationAsNewSheet

How can I use a different line to put the chart in a sheet e.g. Sheet_Chart
that is already present, in a particluar place?

I have posted this question here ->
http://www.excelforum.com/showthread.php?t=623207 also, but have not yet got
an answer.

Thanks
Dave
 
From the object browser in the VB Editor:

Function Location(Where As XlChartLocation, [Name]) As Chart

so try this:

ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1"

- Jon
 
Back
Top