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 -

javascript - How to bind ViewModel Store to View? -

recursion - Can every recursive algorithm be improved with dynamic programming? -