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

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

android - How to prevent keyboard from closing when bottom dialog is open? -