vba - Excel charts pastespecial format -
excel offers possibility paste chart format chart (in chart sheet) through pastespecial.
recording procedure macro gives following code:
sub macro4() activechart.chartarea.select activechart.pastespecial format:=2 end sub
trying run fails (method not found).
i referring here chart sheet , not embedded chart.
please advise.
Comments
Post a Comment