activesheet.shapeschart

  1. D

    MACRO for pie chart

    Hey guys keep getting an error msg of object variable or with block variable not set..excel highlighted the string of code that may be giving me the issue I a completely stumped need help! the code is below..any help is appreciated Sub Macro5() ' ' Macro5 Macro ' ' Keyboard Shortcut: Ctrl+e '...
    • dsequeira
    • Thread
    • activesheet.shapeschart cht excel & vba help - macros macro - formula
    • Replies: 0
    • Forum: Excel Questions
  2. T

    Selecting Cell Reference by Matching Text in VBA

    I'm very much a novice when it comes to Marcos & VBA but after reading loads of posts on this great forum, so far have managed to achieve the basic on what I'm trying to do. Now I'm a little stuck and getting out of depth! So I have a user form with one button that allows a txt file with a...
  3. K

    Macro to create a chart

    I need to create lots of pie charts for a dashboard and was hoping to record a macro that I could run once I have selected the data. However the macro fails here: Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+z ' ActiveSheet.Shapes.AddChart.Select ActiveChart.ChartType =...
  4. The_Rock

    Excel to Powerpoint with Source Format

    Hi Guys I have a code which copies from Excel to Powerpoint which works great. I am not trying to tweak it with the following bit of code to preseve the source format. PPSlide.Application.CommandBars.ExecuteMso ("PasteSourceFormatting") What I then need to do is select the pasted chart and...
    • The_Rock
    • Thread
    • activate activesheet.shapeschart chart original ppviewslide
    • Replies: 2
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top