Move an embedded chart on a worksheet to a chart sheet with VBA
Move an embedded chart on a worksheet to a chart sheet with VBA
(OP)
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





RE: Move an embedded chart on a worksheet to a chart sheet with VBA
ActiveChart.Location Where:=xlLocationAsNewSheet
RE: Move an embedded chart on a worksheet to a chart sheet with VBA
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Move an embedded chart on a worksheet to a chart sheet with VBA