Move an embedded chart on a worksheet to a chart sheet with VBA 2

[bacon4life]

Does anyone know how to move an embedded chartObject from a worksheet to a separate chartsheet with VBA. Manually I would just right click and select move to new sheet but I can't find an equivalent VBA command.

Since it is a chartObject, I can't use Charts.move. Chart.add will create a new chartsheet, but I can't figure out how to move the chart from Sheet1 over to the newly create chartsheet.

Thanks

 

[Hoaokapohaku]

This will work if the chart is active. If not, replace "ActiveChart" with the name of the chart object.

ActiveChart.Location Where:=xlLocationAsNewSheet

 

[IRstuff]

Have you tried the macro recorder with your operations?

TTFN
faq731-376

 

[bacon4life]

Thanks, both of those work great.