Paste As Enhanced Metafile

Resolved · Medium Priority · Version 2010

Mon 29 Sep 2014, 09:39 Delegate Mark said...

Mark has attended:
Excel VBA Intro Intermediate course
Excel Advanced - For Power Users course
Excel PowerPivot course
Excel Dashboards for Business Intelligence course

Paste As Enhanced Metafile

Currently have the following line of code, I'm trying to paste a chart from Excel into Powerpoint as an Enhanced Metafile but I can't seem to get the correct format in the VBA;

ActiveSlide.Shapes.PasteSpecial(DataType:=ppPasteMetafilePicture).Select

Thanks,
Mark

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips

Paste As Enhanced Metafile

Paste As Enhanced Metafile

Excel articles

Excel tip:

Return to the active cell after scrolling