Hi Guys,

In a macro I have the following line:

ActiveChart.Location Whe=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 Whe=xlLocationAsObject, Name:="Sheet1"

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Dave" wrote in message
...
Hi Guys,

In a macro I have the following line:

ActiveChart.Location Whe=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