cut/paste a chart with a Macro?
Posted by Ted on May 02, 2000 10:14 AM
When trying to cut a chart and then paste it in a different location on the same
work sheet with a macro I get a Error."Unable to get ChartObjects property of
the worksheet class".
This is the macro I tried to use but got an error "Unable to get ChartObjects
property of the worksheet class".I ran debug ( it pointed to the part I
marked***).Thanks for any help.
' Macro1 Macro
' Macro recorded 5/1/2000 by
ActiveWindow.Visible = False
ActiveWindow.WindowState = xlNormal
ActiveWindow.WindowState = xlMaximized
*** ActiveSheet.ChartObjects("Chart 2").Activate ***